How can I create a slicer that shows me the content of a table (name months) or another table (number week), depending on the selection of another filter. I want that the user can choose to see by months or by weeks. In case the user wants to see by months in the slicer only has to show the column mon_name of the table month, on the other hand if the user selects week it has to show week_num of the table Week.
To try to do this I have created an auxiliary table which can be selected between month or week and a measure that returns me which value is being chosen. But when I add this measure to the filters of one of the tables, the whole filter does not disappear but only does not show me the months that are not selected.
Thanks for your help!
1 ACCEPTED SOLUTION
@Anonymous , there is one option using field parameters
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-202587d4dedb
Hi @Anonymous ,
I think this example may help you. Firstly I create two tables.
Next I create a measure.
Project Selected = IF ( SELECTEDVALUE ( 'T2'[Project Status] ) = "Completed", 1,0 )
Then put the measure into the visual level filter.
Finally you will get what you want.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , there is one option using field parameters
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
https://medium.com/@amitchandak/power-bi-power-bi-create-dynamic-slicers-using-field-parameters-202587d4dedb
