Log In
Register
Home
April 25, 2022
Offline
Hi,
I have a dashboard in where once I filter to a certain month, the 13 months roll will show in the visual. That is already fine but the problem is there are sections in the dashboard that should only show the data of the filtered month. Problem is its showing the data of other months. I'm thinking because of the no relationship between my calendar. Is there a dax for this to fix?
In the attached PBI project, those with red text in the Risk and Audit is the issue. If I filter to February, it should only show "You have 4 action plans. Please close these before their due dates". The other one that is appearing as well is January despite the month is filtered to Feb. If the data of Jan and Feb is the same, it will only appear once so its doing a total but what if the data is different it will show 2 rows like on my sample.
Hope you can assist. Thanks
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Emanuelle,
I checked the source data in your pbix file, and as you can see in the attached screenshot, those 2 entries are in february, not one in january as you mentioned, so I expect to see them both in the data table.
April 25, 2022
Offline
Hi Catalin,
Thanks for checking the file.
Actually I need to filter to the office slicer as well not only on the month, apologies for not stating that above. So technically, once I filter to an office and to a month it should only show 1 row of data or statement. From the one you have attached in the screenshot, noticed that the offices in the office column are different which are Curacao and Delaware. If we are to filter only on Curacao the data for Jan and Feb is different(as attached in my screenshot) which will show 2 rows. I only need to show 1 row of data depends on the month and the office filtered. So for Curacao, if I filter to Feb it should only show "You have 14 action plans 4 action plans are overdue"
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Emmanuelle,
The reason is that you are using in Month filter a field from Calendar 2, which does NOT have a relationship with per country table. You have only one relationship, between Calendar and per country.
Add a relationship between Calendar 2 and per country table, OR, use use in Month slicer a month field from Calendar instead of Calendar 2.
1 Guest(s)
