Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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's avatar
    Anonymous
    4 years ago

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

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you amitchandak 

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

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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