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?
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
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?
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" ?
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?
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.
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.
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.
Thank you, Thank You, Thank You, exactly what i am looking for, you made my day !. How can i calclulate YTD Value if i make same calculation by Month. I did Value & % (Revenue) by month JAN-DEC, i would like to get end of of JAN YTD Values, could you please help?
excellent but tabular editor is little bit tricky, could you please explain how to create a group in tabular editor, what you created a measures in this video just difficult to understand can u explain it....
![“อาร์ต พศุตม์” เกือบเอี่ยวทุกคดีดัง เอ๊ะไว้ก่อน ไม่มีอะไรได้มาง่ายๆ | แฉ 16 ต.ค. 67 [2/3] | GMM25](http://i.ytimg.com/vi/0Gx-0-kUBv8/mqdefault.jpg)
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?
no external tools is visible
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
Excellent Chandeep! Thanks for the tips on using a Calculation Group. Very useful! Thumbs up!!
Very good video and useful video. Thanks chandeep for sharing your knowledge with us.
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?
This rocked man thank you so much!
glad you like it!
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" ?
Hello, amazing trick for us accountants creating P&L in PowerBI. Thank you.
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?
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.
can we have the month also in the column to view it for comparing the monthly values?
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.
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.
Thank you for the tips! Appreciate if you could share on how to do conditional formatting on calculation group
Any solution you found for the conditional formatting Calc groups?
@Chandeep, how do you change the order of the columns in a matrix?
Without tabular editor, is this possible. Knowledge provided is superb. I recently. Listened some videos
Not yet.. hopefully Microsoft will soon release this feature natively in PBI.
You saved my day!!! Thanks a lot.
Glad it helped!
Thanks for Video, it is very useful...😊😊😊😊
Thank you, Thank You, Thank You, exactly what i am looking for, you made my day !. How can i calclulate YTD Value if i make same calculation by Month. I did Value & % (Revenue) by month JAN-DEC, i would like to get end of of JAN YTD Values, could you please help?
Your videos are always fascinating, nice video and explanation
How did you add the highlighter on the operating profit?
Very well explained... Thank you Chandeep!!
excellent but tabular editor is little bit tricky, could you please explain how to create a group in tabular editor, what you created a measures in this video just difficult to understand can u explain it....
why you dont blink?
Good trick, thanks mate!
Thanks a lot ,That was helping
Thanks for Guiding us
Awesome video!
I want to do your course. But it's kinda expensive for me..
Extremely useful
sir.. how can i contact you for course training?
The links are in the description. You can join any of training programs.
Hope this helps
Thanks
Cool. Thanks!
Thanks!
Thank you sir
where is this option in 2024 version
Ohh its more advanced level ..please goodly if ur video has advanced content build it step by step with us rather then explaining