Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello, I am trying to reference a date column to a slicer. First, I have created a query table that has this selection/values:
Slicer 1:
The objective is when I selected a value in slicer 1, the selection should update in slicer 2. Here are the example options for Quarterly, Monthly, and Weekly from my date table that I am trying to reference with:
Quarterly:
Monthly:
Weekly:
Here is my dax formula. However, I am not sure how to write for it to be referenced using switch:
Solved! Go to Solution.
@ironboy0418 I think this may help, the field parameter feature, You may have rename your columns
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
@ironboy0418 I think this may help, the field parameter feature, You may have rename your columns
Power BI- Create dynamic slicers using field parameters: https://youtu.be/H2ZxWaHAJZQ
Thanks for this! @amitchandak I didn't realize that there is an option for this 🙂 great!
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
23 | |
15 | |
15 | |
10 | |
7 |