Forum Discussion

algunn14's avatar
algunn14
Frequent Visitor
3 years ago
Solved

I need help creating a dimension selector

I want to create 2 slicers: Slicer 1: Values: Weekly, Monthly, Quarterly Slicer 2: Values will be dependent on slicer 1. For example, if the 'Monthly' selection is made on slicer 1, slicer 2's val...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi algunn14 ,

    We cannot do this directly.

    Please refer to my pbix file to see if it helps you.

    Create a measure.

    Quarterly = var _1=SELECTEDVALUE(date_range_table[Date Range])
return
IF(_1="Monthly",BLANK(),MAX(Date_Table[yyyy_qq]))

    Then put the Date_Table[yyyy_qq] and Date_Table[mmm-yyyy] to two slicers. Then filter the two slicers.

    Then hide the two slicer titles.

    I have also found a similar post, please refer to it to see if it helps you.

    Solved: Slicer Filtering Another slicer - Microsoft Power BI Community

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi algunn14 ,

We cannot do this directly.

Please refer to my pbix file to see if it helps you.

Create a measure.

Quarterly = var _1=SELECTEDVALUE(date_range_table[Date Range])
return
IF(_1="Monthly",BLANK(),MAX(Date_Table[yyyy_qq]))

Then put the Date_Table[yyyy_qq] and Date_Table[mmm-yyyy] to two slicers. Then filter the two slicers.

Then hide the two slicer titles.

I have also found a similar post, please refer to it to see if it helps you.

Solved: Slicer Filtering Another slicer - Microsoft Power BI Community

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

algunn14's avatar
algunn14
Frequent Visitor
3 years ago

Thanks for the response! I was hoping there was a solution that would involve one dynamic field, but if that is not possible than this is probably the next best option. I'll leave this as unresolved for now to see if others know of a way, but if I don't get any traction I'll mark this as the solution. Thanks again, I really appreciate the support.