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.
Hi,
I want to apply different date slicer for different column in my grid.
eg:
Here, I want to compare metric 1 (for a specified date range) to metric 2 (for a different specified date range.
Please Help!
@Anonymous
One way of doing it:
1) create a duplicate of your date table, with no relationship with your fact table
2) create measure for your metric 1
3) create a metric measure which filters your date table based on the selection in your second date table (Metric 2 Date table):
Metric 2 = CALCULATE(SUM('Fact Table'[Target]);
TREATAS(VALUES('Metric 2 Date Table'[Metric 2 Month-Year]);'Calendar'[Month-Year]))
and you get this:
Proud to be a Super User!
Paul on Linkedin.
Please refer my blog, hope that can help
Comparing-Data-Across-Date-Ranges
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |