Reply
lg1551
Resolver II
Resolver II
Partially syndicated - Outbound

Stacked Bar Chart - Need Decimal on one Bar, Percentage on Another (only with slicer selection)

I have a stacked bar chart on a slicer which uses two measures (one for each bar).

 

Both metrics should be decimal format, UNLESS a slicer selection is made, then one measure (bar) should be formatted to a percentage. 

 

I've written the percentage measures for these slicer selections, and as a measure in and of themselves, they display properly in the bar chart.

 

But when I write the toggle measure to use those % measures when the slicer is made, it defaults them to decimal. I've even tried using the FORMAT function in the measure to force it but it won't work.

 

Is this even possible in PBI?

1 ACCEPTED SOLUTION
lg1551
Resolver II
Resolver II

1 REPLY 1
lg1551
Resolver II
Resolver II

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)