Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.