Forum Discussion

Magesen's avatar
Magesen
Regular Visitor
1 year ago

Yes or No slicer

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

 

Tips and Tricks

2 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    1 year ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.