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 a table similar to this
and a date slicer
What I want is that when a date slicer is applied like in this case the table should display only two rows '23 Feb' and '26 Feb'. Not the other two rows where the started at is null. However when no date filter is applied the table should be the complete table including all the null dates like this
Here is the pbix file
Solved! Go to Solution.
IsFiltered = IF(ISFILTERED('Table'[Started at]) && ISBLANK(SELECTEDVALUE('Table'[Started at])),0,1)
Create a measure like this and apply filter on the table to see only values where IsFiltered is 1.
When no filters:
With filters:
Proud to be a Super User!
Hi,
you can use https://wetransfer.com/ and share a link with pbix file. 🙂 It will be easier to help you with this challenge.
Proud to be a Super User!
Thank you so much, I have updated the post with the pbix file
IsFiltered = IF(ISFILTERED('Table'[Started at]) && ISBLANK(SELECTEDVALUE('Table'[Started at])),0,1)
Create a measure like this and apply filter on the table to see only values where IsFiltered is 1.
When no filters:
With filters:
Proud to be a Super User!
One more thing if you could help. I want the scorecards to be filtered as well , so in this case the value should show 2 instead of 4
I tried applying the filter on this scorecard but it remains static and doesn't change 🤐
Wish I could accept it a million times, Thank youuu
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |