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 all,
I'm a little lost; I want to present my users a slicer where they'll 2 options: show everything or only show last month. But what I've been trying now is resulting in calculated columns based on my datedim. Then they are like this:
Show everything or last month = if(date[Is last month]="Yes";"Show only last month";"Show everything")
But what happens is complete right but not what I want: if people choose "Show everything" you see everything except the last month. I think the solution will be easy, but for now I don't see the right solution.... Anyone who can help?
Solved! Go to Solution.
Hi @MiKeZZa
One way or another, you will need another table to to allow selection of different periods that overlap.
Possible methods:
Regards,
Owen
Hi @MiKeZZa
One way or another, you will need another table to to allow selection of different periods that overlap.
Possible methods:
Regards,
Owen
Thank you. So easy, so simple. But I had a lockdown of my brain 🙂
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |