Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Running into a "fun" problem. Have a report that looks like below. The State values in Columns are based on a State column and the 2 values are based on a filter in the Matrix visual. I am trying to create a % change and can't seem to figure it out since I don't have 2 different columns, I have just 1 that shows 2 or 3 values based on a filter. Any good way you have solved this? Appreciate all the help!
California | Michigan | |
120 Days | 150 | 175 |
90 Days | 200 | 235 |
60 Days | 250 | 295 |
30 Days | 300 | 355 |
14 Days | 350 | 415 |
7 Days | 400 | 475 |
3 Days | 450 | 535 |
Event | 500 | 595 |
Post Event | 550 | 655 |
Total | 3150 | 3735 |
hI @AllenVaysberg ,
To make the calculation easier I would remove the total row and unpivot the location columns and then use this measure:
Percentage =
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALLSELECTED ( 'Table'[Category] ) )
)
Please see attached pbix for details.
Proud to be a Super User!
Thanks for the effort but I don't want a % of total, I need a % of change between the 2 values. So 150 to 175 what is the % of change.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
109 | |
106 | |
90 | |
61 |
User | Count |
---|---|
165 | |
136 | |
134 | |
97 | |
86 |