Create customized slicer

[diego9010]

Hi everyone,

I need to create 2 customized slicers.

First, I want to be able to filter the graphs based on selection of co2, torque, net content or brix. I created 4 columns showing this info but the slicer wont appear correctly.

The other one is a slicer based on limits: ≥1.33 & ≤3, <1.33 and >3.

Something like this:

I had to create 4 slicers for the limits, but id like to have them in just one:

Links are:

http://www.mediafire.com/file/k8f48dbfwfdxzcx/CPK_final.pbix

http://www.mediafire.com/file/ejtcxxqmgj3bdcz/cpk_dashboard.xlsx

[v-piga-msft · Accepted solution]

Hi @diego9010,

You could try to use the feature Unpivot Column in Query Editor.

1.  Choose the four column in orange by "Ctrl+ click" and Unpivot the column in Query Editor.

And do the same option for column "CO2 limits","Torque limits"," Net Content limits","Brix limits".

2. Then Apply and close.

3. Create the slicer.

For further, you could have a reference of this article.

Hope it can help you!

Best Regards,

Cherry

[diego9010]

Nice feature!

Should I leave the cpk brix,cpk co2, cpk torque and cpk net content as it is or unpivot them too?

I see the options unpivot columns, unpivot other columns and unpivot columns selected. I clicked on the first one and got this:

I got the slicers but atribute, atribute 1 and value are not moving. Which ones should I use?

 

I appreciate a lot your help.