Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a Power BI report with two filters. One filter is the Power BI's default slicer filter (customized to dropdown). The other is a Chiclet Slicer from the Market Place. I want the options in my default slicer to change as the selected value in my chiclet slicer changes.
To explain more, here is the issue:
Solution expected:
My idea for this is to have a custom column that does a switch on SelectedValue of Chiclet Slicer and picks either column. Here is what I have right now:
WarehouseDynamic = SWITCH(
SelectedValue(UnitOfMeasure[UoM])
,"Pounds", DataTable[WarehouseDefault]
,"Kgs", DataTable[WarehouseDefault]
,"Metric Tons", DataTable[WarehouseDefault]
,"Count", DataTable[WarehouseInternalExternal]
)
Problem with this is, I doubt SelectedValue works with a custom column. It only works with Measures. I cannot use a Measure because Measures only return aggregated numeric values or other measures, not columns.
I would highly appreciate some assistance.
Solved! Go to Solution.
I doubt this possible to change one slicer based on another slicer, refer: https://community.powerbi.com/t5/Desktop/Set-slicer-value-based-on-another-slicer/m-p/908632
https://community.powerbi.com/t5/Desktop/Dynamic-Slicer-based-on-Slicer/m-p/429694
But you can try Hierarchial Slicer of Feb 2020 release
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/
I have a similar issue.
I have one slicer using a measure with 6 options from a table. Table has a second column called sorting.
The other slicers is using a different measure with also 6 options from a 2nd table. This table also has a second column called sorting.
Slicer 1 is used for changing graph 1, slicer 2 is used for changing graph 2.
I would like to use 1 of the 2 slicers to change both graphs at once.
The only link between them are the numbers in both Sorting columns.
Can I use 1 of the slicers (or create a complete new slicer) so both graphs change at the same time?
How to solve this?
Hi @Anonymous ,
Please let me know whether you have solved this problem.
Best Regards,
Icey
@Icey From an answer above, I gathered that filtering one slicer through another is not possible. So we decided to change our business requirements to just have one of the two values in our slicer as a default. Your solution won't work for me because I need dynamic options in slicers, not dynamic axis titles.
Thank you for your help.
Hi @Anonymous ,
If I understand you correctly, you can refer to this post: https://community.powerbi.com/t5/Desktop/Dynamic-change-in-X-Axis/td-p/86167. It does not exactly match your situation, but it can be used as a reference.
Or, you can share me a dummy PBIX file, removing sensitive information and real data, and I'll test for you.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I doubt this possible to change one slicer based on another slicer, refer: https://community.powerbi.com/t5/Desktop/Set-slicer-value-based-on-another-slicer/m-p/908632
https://community.powerbi.com/t5/Desktop/Dynamic-Slicer-based-on-Slicer/m-p/429694
But you can try Hierarchial Slicer of Feb 2020 release
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/
@amitchandak Hierarchical Slicer was new to me when you mentioned it, but unfortunately, there isn't really any correlation between the two slicer values. It was more of a business logic than a data logic, so we decided to change our business requirements to just keep one of the two values as the default, irrespective of the first slicer selection.
Thank you for your help and introducing me to Hierarchical slicers. I anticipate using this in the near future!
Sample data would be tremendously helpful. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The options should change between slicers as long as they are set to cross filter for Edit Interactions.
@Greg_Deckler The options won't change automatically, irrespective of cross-filtering because the two slicer values have no correlation. This was a business related connection between the two slicers, rather than a data based connection. So that doesn't work in my case, unfortunately.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |