Forum Discussion
Multi Level Filter
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.
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
Hi Anonymous thank you for your reply. Im afraid Im not sure I understand your questions though, sorry. The source data is a spreadsheet that has many months when a clients account may be due. I only want to look three months ahead. I have all the data in Power BI. The criteria to create the table is also shown below. Does that answer your questions adequately?
query from created from excelcriteria
- ankitpatira
Community Champion
taniabyrnes What you've got is almost correct except for the filters instead of having 'is not blank' change it to 'is greater than' and make it greater than 0.
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
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.