Forum Discussion

taniabyrnes's avatar
taniabyrnes
New Member
10 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
    10 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
10 years ago

taniabyrnes

 

While the solution by ankitpatira requires that every time you have to change the page level filter when you go by different months. From Sep 16 to Oct 16 to Nov 16 to Dec 16 to Jan 17 etc. 

Which in my opinion would be cumbersome and you have to remember this.  

 

The alternative suggested by me will work irrespective the month you are in for the next three months from thereon,

 

Cheers

 

CheenuSing