Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Pbiuserr
Post Prodigy
Post Prodigy

Please help me with hierarchies field parameter workaround

Hello,

18 hr ago Guy in a Cube released interesting video - https://www.youtube.com/watch?v=5G_xSJy5muo 
I have got items and their respective categories and would like to setup a field parameter to distuinguish that (Cat1 and Cat2) and be visible result for them
I've managed to do that but my problem is that i split Cat column into two separated columns and If i select Cat1, then its ok, but the Cat2 is blank and it also is shows in a matrix/chart (as blank)

Item1Cat1
Item2Cat1
Item3Cat2
Item4Cat2
Item2Cat2
1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Pbiuserr 

Make sure your formula is correct after modification.

veasonfmsft_0-1661766501778.png

Please check the sample pbix attached.

veasonfmsft_1-1661766735611.png

 

Best Regards,
Community Support Team _ Eason

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @Pbiuserr 

Make sure your formula is correct after modification.

veasonfmsft_0-1661766501778.png

Please check the sample pbix attached.

veasonfmsft_1-1661766735611.png

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors