Forum Discussion
How to get data range from slicer
Good day I need to calculate the days between the data range of a slicer. I've been using the ALLSELECTED function but i noticed that the value it gets me is from the table that is linked to the sl...
You could do this a bunch of ways. prob the easiest is to make a text box and use the values functionality to do some like:
This report covers the period min_date to max_date
If you havent done this before heres the MS page on how to do it:
Add text boxes, shapes, and smart narrative visuals to Power BI reports - Power BI | Microsoft Learn
Hope this helps,
Cheers,
The thing is that i need the values for a measure, and it has to be the same values in the date slicer regardless of the filter in the status slicer. If i select the dates from 10/1/2022 to 12/15/2022, it should count 14 days whether the status slicer is in "ABORTED" or not