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 Everybody,
I searched alot on this topic but didn't find any solution so far. I would appreciate any help.
I have a date range filter on a page and I want it to show last 30 days range by default, and if I wanted to see other date ranges I would like to be able to chnage the start date and end date on the date range slicer manually.
Every day when I open the report, the date range filter should sow the startd date as today minus one and end date as today minus 31, and the charts shall be displaying the data for same date range.
However if I want to change the date range, I shall be able to change it manually and charts shall show data for that manually changed date range.
Thank you!
Solved! Go to Solution.
you could try the following:
1) make the value on the visual a dax that use a on select option dax statement, so when X condition its true will use a dax using on of the two filter type you telling here or the other
2) add the filters and a third filter with the value that would change the select dax value over the formula
3) possible you will need to use parameters on the dax to be able to do this
Proud to be a Super User!
you could try the following:
1) make the value on the visual a dax that use a on select option dax statement, so when X condition its true will use a dax using on of the two filter type you telling here or the other
2) add the filters and a third filter with the value that would change the select dax value over the formula
3) possible you will need to use parameters on the dax to be able to do this
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |