Skip to content

PowerBI

PowerBI topics

Power BI – split budget into ratios via DAX

  • ilyar126 

In certain times, you would like to split a higher grain number into lower grain by using some percentage ratios. For example, if you have a budget for Product Brand all up, we want to split further the budget into Product Names based on last year’s sales percentage ratios. You can do this by: Procedure steps to split budget categories First, we have the high-level budget figures for the next… Read More »Power BI – split budget into ratios via DAX

Sum of all numbers from 1 to n

You all had this experience at least once. You have to calculate the sum of all numbers to n, so naturally you start counting and counting, starting all over again because you made a mistake and finally using a calculator to get the answer. Well I don’t want to ruin your day but you did everything wrong. There’s a much simpler way to do this. Here’s how: Formula to calculate… Read More »Sum of all numbers from 1 to n

Power BI: add KPI arrow triangles to your Variance Metrics

Anybody up for coloring Egyptian pyramids with Power BI? Just kidding ๐Ÿ™‚ How about creating nice looking triangle arrows for your comparison measures colored dynamically based on the values. My goal is to assign up and down arrows or rectangles next to the year-over-year (yoy) growth percentages, colored green for going up and red for going down. The measure next to the percentage arrows should look something like that: Follow… Read More »Power BI: add KPI arrow triangles to your Variance Metrics

Formatting Calculated Items of Calculated Groups in Tabular Editor

In the previous post I explained how to create Calculated Groups (Calculated Groups – comparisons and calculated columns in a pivot directed by slicers ยป Data Empower), here I will talk about how to create different formatting for the calculated items. For those of you created Calculated Groups in PowerBI using Tabular Editor (Tabular Editor), there are situations where some of the items need to have different formatting. For example… Read More »Formatting Calculated Items of Calculated Groups in Tabular Editor

Calculation Groups – variances in a pivot directed by Slicers

I want to show a situation how using Calculation Groups we can create a pivot or matrix in which using 2 different drop downs (slicers), a user would compare different versions of data in the pivot and their variances. For example, if in the slicer 1, you select Brand A and in slicer 2, you select Brand B, then in the pivot you will see Brands A and B side-by-side… Read More »Calculation Groups – variances in a pivot directed by Slicers

Subtotal Counters within Groups and Subgroups for Calculated Columns

Very often there is a need to calculate counts of various elements within groups or subgroup. This is very useful for calculating ratios. They key element of a ratio is to get the right denominator within desired filter context. Here I will describe the easy way to get any desired count of a group or a subgroup in the calculated column that could be later used for the ratio’s denominator.… Read More »Subtotal Counters within Groups and Subgroups for Calculated Columns

Connect Excel to PowerBI Desktop

There are a few ways to connect Excel to a PowerBI Desktop file. The easiest way meanwhile is to use DAX Studio (can be downloaded for free here: https://daxstudio.org/) Steps are as follows: 1. Open PowerBI Desktop file that you want to connect to. In my case I opened CoronaPBI file that I was working on. 3. In the DAX Studio, enable these options: Show External Tools should be checked.… Read More »Connect Excel to PowerBI Desktop