Hyperlink multiple slicers to a link
Dear Team, I have a test link https://powerbi.com/reports/powerbi/Production/testData_abcd and a slicer called "Region" with data: DE, IN, US,... Requirement: if users select a Region option then that value will be added as a tail in the link above. I already found a way with IF formulas: a) RegionSelected = IF(ISFILTERED(Sheet1[Region]),SELECTEDVALUE(Sheet1[Region]),"Select all") b) Formula1= IF([RegionSelected]="Select all","https://powerbi.com/reports/powerbi/Production/testData_abcd","https://powerbi.com/reports/powerbi/Production/testData_abcd?filter=Sheet1/Region eq '"&[RegionSelected]&"'") it meets the request, BUT if we have multiple slicers then I have to create another IF for each slicer and combine all of them in the DAX. It look too lengthy and unprofessional... For example: I have one more slicer called "Component". Another IF have been created as following: c) ComponentSelected = IF(ISFILTERED(Sheet1[Component]),SELECTEDVALUE(Sheet1[Component]),"Select all") d) Formula2 = IF([Formula1]="https://powerbi.com/reports/powerbi/Production/testData_abcd", IF([ComponentSelected]="Select all", [Formula1],[Formula1]&" and Sheet1/Component eq '"&[ComponentSelected]&"'") Question: Do we have another way to sync slicer with a link? Or another concise formula that can solve this problem? Could you please check and support? Thank you.
