Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am having an issue with the Matrix visual. The matrix has Forecast Group as rows and Years (which can change over time) as columns. I created a measure that determines if a year is within a selected date range on an unrelated table.
For example, if the selected date range was from 2019-2021, the "Max BinaryDate" measure would output "1" for all years between 2019 and 2021 and would output "0" for all years outside this date range.
I am trying to use this measure to filter out the columns of the matrix outside the selected date range. It works perfectly if the "Table" visual is used. I have selected years 2021-2023 in the below table and as you can see, only 2021 through 2023 are showing up:
When I convert this table to a matrix with the years as the columns, we can see that the "Max BinaryDate" measure is calculating the correct number (1 or 0) depending on the selected fiscal year. However, when I try to filter "Max BinaryDate", it does not remove columns that are not "1". Also something interesting is that when I filter Max BinaryDate = 0, the entire table gets filtered out.
Any idea why this might be happenning and how to fix it?
For reference, the Max BinaryDate measure is:
IF(
countrows(
values('Utilization Categories'[Concat FcastGroup])) = 1
Man, I wish Power BI supported dynamic calculated columns cuz that would make this so much easier haha!
Thanks in advance!
Brandon
Hi @Anonymous ,
Could you pls share your pbix file ?Remember to remove confident data.
Best Regards
Lucien
Hi Lucien,
I'll try to get you a file with confidential data removed later today. Thanks in advance!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |