Switch Function not working in other visuals such as bar chart.

[sumpekung]

Hi,

I'm trying to see old forums from others but don't see the exact answer U need to know.

I created a switch measure and it's working good with Matrix and Table visuals but it doesn't work with other visual such as Bar and Column charts, it can't even drag the switched measure into the Y axis field.

Note : I use powerBI May-2025 at my company, don't sure powerBI at workplace has more limit than common user or not?

[Zanqueta · Accepted solution]

Hi @sumpekung, If you would like, you may share your exact SWITCH measure and I can help you refine it so that it behaves consistently across all visuals.

Quick verification you can perform now: 

• The SWITCH works in Matrix and Table visuals because they support multiple data types.

• Bar and column charts accept only numeric measures on the Y‑axis.

• If any branch of the SWITCH produces a non‑numeric value, the measure is excluded from the Y‑axis.

• Standardising all returned values to numeric types resolves the issue.

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[sumpekung]

Many thanks, my current measure I try to formatted it because I have to show with Percentage and Whole Number.

My measure:

Sales Display (Formatted) =
SWITCH(
SELECTEDVALUE(DisplayType[Type]),
"Percent", FORMAT([Sales %], "0.00%"),
FORMAT([Total Sales], "#,##0")
)

It can works on bar chart after I removed the Format function. Anyway, does it possible to format it to show in Whole Number and Percentage?