Use Measures in Columns of a Matrix Visual

- - - - My Courses - - - -

- - - - Blog - - - -

[alessandrofazzone]

Hi, I'm looking for a way to read the range of a Slider filter and put that range value in a calculated column, this is because I have to use this calculated column in my pivot table so that when I export the table that column shows me the range of the selected slider. I tried with the MIN, MAX, FIRSTDATE, LASTDATE measures but then I can't use the measures as columns. Do you have any suggestions on how to use the columns? Thanks

[gFowmy]

Thanks for another useful tip, one quick question. When you use calculation group, how do you setup conditional formatting? In your example, how to apply red or green on % change calculation item column?

[juansepowerplatform]

Hello, amazing trick for us accountants creating P&L in PowerBI. Thank you.

[sandeepreddy]

Very good video and useful video. Thanks chandeep for sharing your knowledge with us.

[wayneedmondson]

Excellent Chandeep! Thanks for the tips on using a Calculation Group. Very useful! Thumbs up!!

[toirshad]

Very well explained... Thank you Chandeep!!

[tpvishnutp]

One question:

I use multiple count measures in matrix under values box, and drill through from one measure value to detail page.
There im getting different row count.

Why this happens ?
Please help

[kln]

Your videos are always fascinating, nice video and explanation

[pawankumar-oowq]

In my matrix table has 4 quarters and I created measure for YTD. When I dragged it into matrix table that YTD showing in every quarter but we need YTD in separate column in my table. how can we do that can you please help me on that.

[pksindal]

@Chandeep, how do you change the order of the columns in a matrix?

[شادنابراهيم-ضغ]

How did you add the highlighter on the operating profit?

[Freemachains]

Hey! Very interesting trick!
Actually I'm suffering with measures and calculated coloms if you can help me to solve it please,
I have created a measure for sales amount 2020 (S.A 2020)and a measure sales amount 2021(S.A 2021) then divided (2020 VS 2021)them in percentage to have a measure for customers that you are loosing ( less than 50% of sales amount than last year). Every thing was running correctly except when I decided to sort my clients with the If function : if(2020 vs 2021 >=1, 1, if(2020 vs 2021>=0.5, 2, 3).
It worked in measures, I have 1 if the result is 100% or plus, 2 if it's between 50% and 100% and 3 if it's less than 50%. But I can not slice with the measure, I need to have the same results (1, 2 and 3)in a calculated colomn that I could use to filter my report..
Thanks in advance for the help. <3

[sitisarah]

Thank you for the tips! Appreciate if you could share on how to do conditional formatting on calculation group

[KgasS]

Good one and trying to figure out how to use the calculation gorup. I think for % of Total Sales measure in the calucation part for the switch satement it needs to be the measure ie [Total Sales] and not the text "Total Sales" ?

[sathishkumar_bhutharaju]

Thanks for Video, it is very useful...😊😊😊😊

[shedymandawe]

Hi Chandeep, I have a matrix with two values which is the Planned Output and Actual Output... my columns is weekly so what happens is every week i have 2 columns for Planned and Actual... is there a way where I only want the Planned Output to appear only once since it does not change every week?

[KaartickKS]

Hello, Can we apply or display the LY % change as just the icon using field formatting?? like it should display either increase or decrease in the percentage value.

[PraveenKumar-udkz]

can we have the month also in the column to view it for comparing the monthly values?

[ferdinandsantos]

Hi Chandeep! In your example, what if you have a category slicer and also have the field in column instead of row. Let’s say we only need Value under each selected category. How can you calculate the difference, for example, between first two selected categories, say accessories and bikes? Is this doable?

[darpanarora]

Without tabular editor, is this possible. Knowledge provided is superb. I recently. Listened some videos