Yes or No slicer

[Magesen]

Scenario : A company have local and foreign resources. I already have a measure called "Foreign" which will calculate number of foreign resources. There are multiple dashboard showing different segment of resources example by age, by technology, by years or experience etc. My question is how to create a new slicer name "Foreign" the value need to be Yes and No. If user select Yes, all the dashboard to show the value of Foreign resources only. If user select No, all the dashboard to show the value of local resources only. How can achieve this. pls advise. TQ

[Anonymous]

Hi, @Magesen 

Has your problem been solved? If not, can you provide more example data and what you expect as output?

Best Regards,

Community Support Team _Charlotte

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

[rajendraongole1]

Hi  -You need to first create a calculated column that flags whether a resource is foreign or local based on your "Foreign" measure. This will categorize the data as "Yes" (Foreign) or "No" (Local).Go to the table where your resources data exists and create the following calculated column:

Foreign Status = IF([Foreign] = 1, "Yes", "No")

 

This will create a new column that marks each resource as either "Yes" (Foreign) or "No" (Local).

Drag the newly created Foreign Status column to the report canvas.Convert it into a Slicer visual by selecting the slicer option from the visualization pane.This slicer will now have two options: "Yes" and "No."

Hope the above steps helps your to derive the expected result. 

@Magesen