Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to use two different date range slicers to filter the order volume for a before and after period. I believe I need to create a new calculated table with a different date field, but I am unsure of the DAX required for this. Right now, both the date slicers are filtering both columns. Any insight would be great, thanks!
Solved! Go to Solution.
@helpplease1234,
You can use “Edit interactions” feature in Power BI Desktop to achieve the above requirement.
In your scenario, create two card visuals using the order volume field. Firstly, click on the first date slicer, turn on “Edit interactions” under Format ribbon, then select “None” for the second card visual and select “Filter” for the first card visual.
Secondly, click on the second date slicer, then select “None” for the first card visual and select “Filter” for the second card visual. This way, you can use the two different data range slicers to filter the two card visuals separately.
Regards,
Lydia
@helpplease1234,
You can use “Edit interactions” feature in Power BI Desktop to achieve the above requirement.
In your scenario, create two card visuals using the order volume field. Firstly, click on the first date slicer, turn on “Edit interactions” under Format ribbon, then select “None” for the second card visual and select “Filter” for the first card visual.
Secondly, click on the second date slicer, then select “None” for the first card visual and select “Filter” for the second card visual. This way, you can use the two different data range slicers to filter the two card visuals separately.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |