The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |