Dynamically change the information within a visual via a slicer >>> FORMATTED

[ovetteabejuela]

Hi,

@EnterpriseDNA posted this awesome blog Dynamically change the information within a visual via a slicer and I was able to follow it however when I tried to FORMAT the measures the graph stopped working. I'm trying to format the visuals to a percentage "0.00%" so it will show up properly in other tiles such as the Card.

Is there something that I'm missing that prevents me from doing so?

so instead of just:

Measure Selection = 
SWITCH( TRUE(),
	VALUES('Measure Dimensions'[Measure]) = "Total Sales", [Total Sales],
	VALUES('Measure Dimensions'[Measure]) = "Total Costs", [Total Costs],
	VALUES('Measure Dimensions'[Measure]) = "Total Profits", [Total Profits],
	BLANK())

I'd like to do (for example):

Measure Selection = 
SWITCH( TRUE(),
	VALUES('Measure Dimensions'[Measure]) = "Total Sales", FORMAT([Total Sales],"0.00"),
	VALUES('Measure Dimensions'[Measure]) = "Total Costs", FORMAT([Total Costs],"0.00"),
	VALUES('Measure Dimensions'[Measure]) = "Total Profits", FORMAT([Total Profits],"0.00"),
	BLANK())

[Sean]

FORMAT converts everything to Text (that's why the graph is not working anymore - but in a table or matrix you should be fine)

Luckily you want you want all 3 Measures to be the same format

Select and Format in the Modeling tab the SWITCH measure itself as %

[ovetteabejuela]

I see, that would explain it. UNFORTUNATELY, I'm planning to add more metrics into it with mixed data type. Hmmmm.... I'll try to figure out something if that is the case.

[tjd]

With respect to your future goal of mixing data types, the original article contains a caution that you cannot mix data types at this time.  Just giving you a heads up.

[ovetteabejuela · Accepted solution]

Hi @Sean & @tjd,

I just want to recognize that there is now way at the moment to accomplish what I needed both in OOTB solution or even a workaround.

By the way @tjd, I will not have mixed data type at a single time in any chart, it might not look good imagine mixing percentage and integers.

What I was refering to was the for the single chart to accomodate different data types but only one data type in a single time, say:

Measure Selection = 
SWITCH( TRUE(),
	VALUES('Measure Dimensions'[Measure]) = "Total Sales", FORMAT([Total Sales],"0"),
	VALUES('Measure Dimensions'[Measure]) = "Total Costs", FORMAT([Total Costs],"0.00%"),
	VALUES('Measure Dimensions'[Measure]) = "Total Profits", FORMAT([Total Profits],"0.00"),
	BLANK())

Closing the thread as Solved, but to point out... there is no currently a solution to the situation