topic Values format change in DAX Commands and Tips

Values format change

Anonymous — Wed, 27 Apr 2022 10:20:04 GMT

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!

Re: Values format change

amitchandak — Wed, 27 Apr 2022 10:56:46 GMT

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/

Re: Values format change

Anonymous — Thu, 28 Apr 2022 08:09:49 GMT

Thank you amitchandak

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

Re: Values format change

Anonymous — Tue, 03 May 2022 13:01:33 GMT

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

Re: Values format change

Anonymous — Thu, 05 May 2022 06:07:43 GMT

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