Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a matrix that requires a visual filter (it's a 1 or 0 flag that gives me month to date compared to this time last month and this time last year on the same month).
For asthetic reasons the matrix needs to have the dates in the columns along the top. As soon as I move them from row to columns the visual filter no longer works. Apparently the visual filter on a matrix only applies to rows.
Is there any way to make a visual filter apply to columns on a matrix?
Hi @Anonymous
It seems you may use 'Unpivot columns' to model your data or create measures to get it.Sample data and expected output will be helpful to provide an accurate solution.If you need further help,please follow the How to Get Your Question Answered Quickly to post your simple assumed data and expected output.
Reference:https://community.powerbi.com/t5/Desktop/Filter-by-Column-heading-in-matrix-visual/td-p/330344
Regards,
Hi @v-cherch-msft, thanks for the reply.
Ok, apologies maybe I did not include enough detail.
I'm using the following DAX measure:
Flag = IF(ISBLANK(min('Month to Date'[This Month]))&&isblank(min('Last Month to Date'[Last Month]))&&isblank(min('Last Year to Date'[Last Year])),0,1)
I want to then filter the 1s so the dates on the columns only appear if they have a 1 on the Flag measure.
It works perfectly when the date hierachy is on the rows, but as soon as I move it to columns it ignores the visual filter.
Hi @Anonymous
Could you share some data sample or some screenshots?
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |