Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ignoring visualisation field level filters

Hi Power BI folks,   I have been trying to solve this problem for a while. What if you wanted to not create a YTD line chart but a chart that starts at a custom period and ends at a custom period. ...
Need Help
Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

I am not sure if I understand your question correctly. To create a cumulative sales based on a custom start and end date with a model where you have a single dates tables connected to a fact table, you follow this mesure. I have used ALL here so the the starting value is accumualted since the date when values are avilable, you can change it to ALLSELECTED to start the values to acumilate from the the minimum date. This ignores filters applied to the dates table frrom any place on your report.

**bleep** Sales = 
VAR __MinDate = CALCULATE( MIN('Calendar'[Date]) , all( 'Calendar' ) )
RETURN
CALCULATE(
    SUM(Sales[Value] ),
    'Calendar'[Date] >= __MinDate,
    'Calendar'[Date] <= MAX('Calendar'[Date])
)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Fowmy, thank you for your reply. 
    The problem that I'm having is that I want to filter on the values of the slicer. Ignoring any filters on the visual. 

     

    For example: If I create a line chart and add months to the X-axis, the MIN(Date) and MAX(Date) of January will be 01/01/2023 and 31/01/2023. My slicer has been filtered to show values between  01/01/2022 and 01/01/2024. These are the values I want to access.