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 am wondering if there is a way to NOT show items in a matrix with no data passed a certain date range.
If the item has data after the date range then it would show again.
I do know about "Show Items With No Data", but I am looking for something a little different.
Still needs to show Items if they had data yesterday, but if it was totally blank from 14 days back then do not show the item.
Example of the current matrix -->
Solved! Go to Solution.
You can set a filter on the visual.
Create a Calculated Column that has 1 if the data you want is there and 0 if it's not.
Then filter the visual based on that Calculated Column.
If you need more details, please share the format of your input table.
You can set a filter on the visual.
Create a Calculated Column that has 1 if the data you want is there and 0 if it's not.
Then filter the visual based on that Calculated Column.
If you need more details, please share the format of your input table.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |