Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 🙂
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |