Forum Discussion

taniabyrnes's avatar
taniabyrnes
New Member
9 years ago
Solved

Multi Level Filter

I have a matrix, I'd like to be able to exclude all rows that have a zero value in Sep 16, Oct 16 AND Nov 16. The filters seem to work on their own and you can add an and/Or Filter within each month,...
Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    taniabyrnes I see your problem. Way to overcome that is in power bi desktop go to query editor -> then add conditional column under Add column tab as shown below -> then in page-level filter use that conditional column to be equal to 1.

     

taniabyrnes's avatar
taniabyrnes
New Member
9 years ago

ankitpatira thank you for your reply, but that doesn't work. As soon as I do that, it filters out every record except those that have a value in November.

 eg. For November I chose that, but I want it to filter to show all records that have a greater than 1 value in Sep, Oct OR Nov.

 

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
9 years ago

taniabyrnes I see your problem. Way to overcome that is in power bi desktop go to query editor -> then add conditional column under Add column tab as shown below -> then in page-level filter use that conditional column to be equal to 1.