Forum Discussion
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 ...
I'm afraid slicer can't filter the format of value. Slicer can only filter rows in the visuals.
Regards,
Jimmy Tao
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?