switch function only show 1 value

[SelflearningBi]

Hi stilll leaning how to do dax and all kinds of stuff,  I am trying to create a column that display turnover % such as 0~3%  3%~6%  6%~9% 9%+
not sure why its only display one as you can see i highlighed in oranger color. 

 this is the turnover % measure I created 

 is it because of my measure ? 

and this is the column function:

% performance = SWITCH(TRUE(),
isblank(turnover%), blank(),

'A_Measure'[Turnover%]<=0,"0%~3%",

'A_Measure'[Turnover%]<=1,"3%~%6",

'A_Measure'[Turnover%]<=2,"6%~9%",

"6% +")

[Anonymous · Accepted solution]

Hi @SelflearningBi ,

It seems like you create a calculated column for the slicer. 

As you can see from my example below, the calculated column does not change dynamically, while the measure canges.

As a workaround, you could create a [% performance] measure uses the original fourmula.

Then create the following table for the slicer by entering data.

Create a measure for the visual level filters.

Measure = IF(ISFILTERED('Table (3)'[performance slicer]),IF(SELECTEDVALUE('Table (3)'[performance slicer])=[performance measure],1),1)

Put the measure into the visual level filters, set up show items when the value is 1.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@SelflearningBi , You should not use a measure in a calculated column , that will not work

You need

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k