Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter value without relationship

Hi All,

 

I have two tables: Fact_Actual and Options. These two data tables have no relationship at all.

In the dashboard, I will have a table and slicer. Table contains only [Value] and [Selection] will be the filter.

If I filter Selection="Yes", I only want to see A+B value

If I filter Selection="No", I olny want to see C value.

If I filter Selection="Maybe", I olny want to see D value.

 

How can I achieve it? Thanks!

 

 

Regards,

BK

Need Help
Show and Tell

3 Replies

  • S_JB's avatar
    S_JB
    Resolver III
    5 years ago

    You could create a new column within the Fact_Actual table. The logic is below:

     

    Options =
    IF('Fact_Actual'[Category]="C","No",
    IF('Fact_Actual'[Category]="D","Maybe",
    "Yes"))
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi S_JB , thanks for the reply. There will be more data than A-D, it will be troublesome to do this method

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        5 years ago

        Hi,  Anonymous 

        I'm not  sure what you mean by  "it will be troublesome".

        According to the information you provided,using the if statement to judge is the most direct solution.

         

         

        Best Regards,
        Community Support Team _ Eason