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
if there there are 2 legends and for one value only one legent have value then i dont want to show that legend. means if both legends have value then only bar should be shown (Source is SSAS)
Create these measures in your SSAS model and use the third one in the visual.
COUNTROWS(
FILTER(
ALLSELECTED( 'Legend'[Legend] ),
NOT ISBLANK( CALCULATE( [Amount] ) )
)
)
COUNTROWS( ALLSELECTED( 'Legend'[Legend] ) )
IF(
[Legends with data count] = [Legends required count],
[Amount],
BLANK()
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 19 | |
| 12 | |
| 11 |