Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Here is the dataset:
Year Type Value
| 2023 | a | 20 |
| 2023 | b | 50 |
| 2023 | c | 30 |
Here is the Visual: I want to see percentage when hover over a category:
Here is how to make the visual:
Here is the DAX I used to make the code:
Measure =
var a = sum('Table'[Value])
var b = if(HASONEVALUE('Table'[Type]), max('Table'[Value]) )
return b / a
But the result does not show an accurate percentage when hovered:
Expected result: 30/100 = 30% and not 100%
Solved! Go to Solution.
Hi @bipowerbix
Please try
Measure =
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Type] ) )
)
Hi @bipowerbix
Please try
Measure =
DIVIDE (
SUM ( 'Table'[Value] ),
CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table'[Type] ) )
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 14 | |
| 7 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 29 | |
| 18 | |
| 17 | |
| 11 | |
| 10 |