Forum Discussion

Keerthika's avatar
Keerthika
Helper I
7 years ago

Dynamically formatting data values in visuals using slicer.

Hi all,

I wanted to customize my "revenue" in terms of #,thousands and million using slicer. It seems to work in card visual. But I also wanted these dynamically in my visuals so it would be easier to analyse. Is there any way to help with this?
Thanks.

Need Help
Tips and Tricks

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Keerthika ,

     

    I'm afraid slicer can't filter the format of value. Slicer can only filter rows in the visuals.

     

    Regards,

    Jimmy Tao

    • Keerthika's avatar
      Keerthika
      Helper I
      7 years ago

      Hi v-yuta-msft 

      I have used measure for formatting the value.

      dynamic format =
      SWITCH(TRUE(),
      SELECTEDVALUE(Formatting[Dimensions])="#",FORMAT([total amt],"#,##.00"),
      SELECTEDVALUE(Formatting[Dimensions])="K",FORMAT(ROUND([total amt],0),"#,##0,.00")&"K",
      SELECTEDVALUE(Formatting[Dimensions])="M",FORMAT([total amt],"#,0,,.00")&"M")
       
      This measure works in card visual. I wanted to format values in charts like bar chart,pie chart,... Can you suggest some possible ways to do it?