Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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()
)
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.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 13 | |
| 10 | |
| 8 | |
| 8 | |
| 7 |