Values format change

[Anonymous]

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).

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!

[Anonymous]

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 · Accepted solution]

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

[amitchandak]

@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/

[Anonymous]

Thank you @amitchandak 

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