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.
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.
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 |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |