Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have this matrix:
Now what I am trying to achieve is make some sort of flag that marks activity in the last 3 years and is not blocked.
So I already have fields that determine if blocked and > 3 years.
I now want to look at the total and if that is greater than 0 there is activity so it will be a "yes" and else "no".
With the other 2 flags I can then do the rest (older then 3 years and not blocked).
I made this measure but cannot use it in the matrix layout and also not in a slicer 😞
Solved! Go to Solution.
Found it 😄
With help of some earlier post I was able to rebuild it so it would work for me.
Will list my solution here for others to find if they are facing similar problems.
I made a measure status like:
Now my slicer works fine on lines with data, for zeros and lines that are blank 😁
Found it 😄
With help of some earlier post I was able to rebuild it so it would work for me.
Will list my solution here for others to find if they are facing similar problems.
I made a measure status like:
Now my slicer works fine on lines with data, for zeros and lines that are blank 😁
Ok...so harder then I thought....
Is there then maybe some other way of giving the user an option to see only the lines where there are no amounts?
I know I can just go into the filter pane and switch on the "is blank" under the values field.
But for my end users this is no ideal solution. I would like a bit more intuitive option for them.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
119 | |
104 | |
77 | |
69 |