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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Changing values, when filter is chnaged in slicer

Hi all,

I have one requirement in my power BI

I have a one measure, I want to show it in both number and percentage format when I change filter in slicer
For example I have #, % in my NB_FAST table _Type column, I have created this NB_FAST table in Power BI.
I will add this _Type column in slicer, if i select #, the measure should give in number format and if I select % the measure should give in Percentage format

How to do that
I already have two mesaure which gives number and percentage separetly
Please help
Thanks!!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, @Anonymous 

In the current version, the dynamization of the Measure format is not possible; if you follow your approach, you end up writing a Measure to filter on #, %, and the format of this Measure is still fixed, simply taking the values of #, %. (If you want to realize the customization of the format, there must have the fx icon)
No vyaningymsft_3-1713235225578.png icon in format pane

 

vyaningymsft_2-1713235189828.png

 

vyaningymsft_0-1713234991454.pngvyaningymsft_1-1713235004138.png


If this feature is important to you, You can submit an idea for here and the product team will take note of such a need.

Related Link: New tab (powerbi.com)

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi, @Anonymous 

In the current version, the dynamization of the Measure format is not possible; if you follow your approach, you end up writing a Measure to filter on #, %, and the format of this Measure is still fixed, simply taking the values of #, %. (If you want to realize the customization of the format, there must have the fx icon)
No vyaningymsft_3-1713235225578.png icon in format pane

 

vyaningymsft_2-1713235189828.png

 

vyaningymsft_0-1713234991454.pngvyaningymsft_1-1713235004138.png


If this feature is important to you, You can submit an idea for here and the product team will take note of such a need.

Related Link: New tab (powerbi.com)

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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
Top Kudoed Authors