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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Values format change

Hi guys,

 

I have a matrix visual which based on the slicer selection shows percent or values. The issue is formating values should be whole number, precent should have % .

The data model has the column with all values, and  the column with type of value (percent, value, denominator).

XeniaLi_0-1651054256431.pngXeniaLi_1-1651054288159.png

Use dax to show values:

Employment =
CALCULATE(
[KPI Value],
FILTER(
'KPI [Dim]',
'KPI [Dim]'[KPI] = "Employment"
))

 

I have measures: KPI Value, KPI percent.

Is there way I can modify this formula so it can switch between precent and values and formating?

Many thanks!

 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

If anyone have similar task, I've done it by using SWITCH and SELECTEDVALUE (based on slicer) then FORMAT (value).

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi   @Anonymous 

I am so glad to hear that you have done it with your workaround . Please consider Accept it as the solution to help the other members find it more quickly. 

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable

If anyone have similar task, I've done it by using SWITCH and SELECTEDVALUE (based on slicer) then FORMAT (value).

amitchandak
Super User
Super User

@Anonymous , if you are using measure slicer and want the format has to change, you need to use calculation group

 

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thank you @amitchandak 

Unfortunately, due to company policies I don't have tabular editor or external tools in Pbi. 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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