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.

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi taniabyrnes

 

1. What is your data model ?

2. What criteria you use to build the three months of the report? is it based on a slicer of 3 months ??

 

Please clarify.

 

Cheers

 

CheeenuSing