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
I need to create a combined graph with two columns and a percentage line.
But when I select two filters from the same column, the graph line is not recalculating the percentage, it only shows the result as average, sum, standard deviation and others.
Is there any solution for this?
Example:
Slicers | Data1 | Data2 | Percentage % |
Name1 | 1,500,000 | 7,300,000 | 21% |
Name2 | 16,300,000 | 36,100,000 | 45% |
17,800,000 | 43,400,000 | 41% |
I need select: Name1 + Name2 with slicers and i need see 41% as value, not average, not sum, etc.
Thanks you!
You just need to add a measure.
Measure = DIVIDE ( SUM ( Table1[Data1] ), SUM ( Table1[Data2] ) )
I have a measure in a card with the global result of the division, which works correctly with the slicers. But i can not use a measure in a combined graph, only was use columns calculated or normal.
In data i have more columns with month, year, area and others.
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 |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |