Forum Discussion
Helper IRemove blank from field parameter and sort by descending
For anyone looking for solution, I unfortunately had to do it the hard way to make the filters user-friendly. That involved creating bookmarks and buttons for various combinations as mentioned in this post - https://community.fabric.microsoft.com/t5/Desktop/Displaying-single-graph-based-off-2-sets-of-bookmarks/td-p/1982459
Helper IThanks again, Edit Interactions helps partially. However, the last filter selection persists when switching between different options in 'Type' and the matrix ends up being blank unless something is selected in 'Content'.
Resolver III see hprose , let me recommend extra solution with field parameters.
if I use this filter for slicer which has blank data , it will generate result you wish I guess.
- hprose
Thank you OguzMavice , my problem is 70% solved. However, it seems like power bi does not allow sorting in descending order so the earliest date is selected instead of latest by default. And only Type Q seems to not have anything selected by default for some reason and therefore leaves the matrix blank.