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 IThank you for your response, I implemented your approach in my file. However, I notice that selecting a value in the second slicer removes options from the first slicer (which is expected).
The reason I was trying to use field parameters was so all the options would be visible to the viewer under 'Type' at all times and both slicers can be single select with the latest week/month/quarter selected. Would that be possible?
Example #1
Exmple #2
Resolver IIHi hprose , if you change settings of interaction on page, you can handle with this problem. you should select content slicer and click edit interaction then off interaction icon on the type slicer.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- hprose
Thanks 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'.
- OguzMavice
I 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.