Changing values, when filter is chnaged in slicer

[Bharathi_99]

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!!

[v-yaningy-msft · Accepted solution]

Hi, @Bharathi_99 

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  icon in format pane

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