Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional Filtering

Hi there,   This is my first time asking a question on the forum so forgive any novicey language and/or ignorance.   Is it possible to action a filter based off another column filter ? Essentiall...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    1 unpivot the column and let the table looks like this:

    2 create a measure and put it in the values of martix table.

    Measure = IF(SELECTEDVALUE('Table'[Value])="FALSE",BLANK(),SUM('Table'[Sales ]))
    Result:


    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

I am still not sure what you want, please can you improve the problem description and I will try help

 

Boolean behaves strangley on Power BI slicer which can be confussing for BI novices.

Try this ...

In the query editor change the True/False data types from Boolean to text or Y/N.

Delete all your slicers values and add them again.

This is much simpler to understand.

If you dont believe me then try compare the behavior of a boolean and text True and False column in a slicer.

 

Novices think that  True and False  boolean  will save disk space compared to text .
That is true on SQL row databases but Power Bi is collumnar database.

So use text and not boolean in Power BI.

 

Please click thumbs upand accept as solution button. ðŸ˜€

If you have 1 query, 1 report visual; and 3 slicers (menswear, kids, sport).

As you you slect one or more slicers the other slicer(s) and report which shink accordingley.

Just like on ebay or Amazon slicers.