Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i have two slicer. ex country and division . if i select contry and it division in filter. then if i clear the country. i need to clear division also. but now Sub slicer of division is not cleared. how to achive this.
Solved! Go to Solution.
Hi @Kk6,
AFAIK, current power bi does not support to use slicer to effect other filter selections. Perhaps you can try to use bookmark to create a bookmark to restore filter selections.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi @Kk6,
AFAIK, current power bi does not support to use slicer to effect other filter selections. Perhaps you can try to use bookmark to create a bookmark to restore filter selections.
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
You can try this - https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-slicer-hierarchy-multiple-fields OR
Using DAX (Power BI only):
Go to the Modeling tab.
Click on New Measure.
In the formula bar, enter the following formula:
ClearSelection =
VAR selectedCountry = SELECTEDVALUE('Table Name'[Country])
RETURN
IF(ISBLANK(selectedCountry),
ALLSELECTED('Table Name'[Division]),
SELECTEDVALUE('Table Name'[Division])
)
Replace "Table Name" with the actual name of your table.
Click OK.
Go to the Format Pane for the division slicer.
Under General, set Selection Mode to Single.
Under Visualizations, set Default value to the newly created ClearSelection measure.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
User | Count |
---|---|
98 | |
90 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |