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 Everyone
I wonder if you can help me. I am working on displaying attriton data and for some reason when putting this into the Matrix visual it is showing me the results for the entire year rather than stopping where we are now i.e. June 2023.
I am using a tables table to show the month/year and the very strange thing is that when putting this into a line graph it does stop at the correct month/year. I have tried all kinds of filters etc but nothing seems to be working.
Any help will be greatly appreciated
N
Hi @Neil_Cooper
Try to add to your date table flag column
Is_before_taday = if (dim_date[date] <=today(),1,0)
And then put it on page/visual filters by 1.
If i isn't work please share your sample PBIX
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you so much for the reply but sadly this didnt work. I tried to use this as a filter but it only had the selection of "1" and nothing else to filter out
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 |
---|---|
98 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |