Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

2 Different Visuals on the Same Report but differing time frames on the X - Axis.

I have a report where the top left  visual is based on a filter called Periods -1, so it always selects our last period by site.  The bottom line chart is based on the filter where this is in cu...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Kaviraj11 , farmdev ,thank you for your quick replies, I'll add more.

    Hi Anonymous ,

    Regarding your question, create measures to populate the visual objects at your bottom.

    The Table data is shown below:

    1.Suppose the only filter I need to pass is the field 'Type'

    2.Creating DAX Expressions with ALL Functions(Removed the filtering effect of the field 'Date')

    ALL function (DAX) - DAX | Microsoft Learn

     

    Measure = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Date]))

     

     3.Final output

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks , but I have used the edit interactions and it is that I cannot get working, every time I click on the site bar in the top left , it acting as if it also sending across the "Periods from Today = -1" filter to the bottom filter. When all I want is the "SITE" filter and leave the date range as Year To Date...   Attached are the visual filters for the tope left and bottom visual....

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Kaviraj11 , farmdev ,thank you for your quick replies, I'll add more.

    Hi Anonymous ,

    Regarding your question, create measures to populate the visual objects at your bottom.

    The Table data is shown below:

    1.Suppose the only filter I need to pass is the field 'Type'

    2.Creating DAX Expressions with ALL Functions(Removed the filtering effect of the field 'Date')

    ALL function (DAX) - DAX | Microsoft Learn

     

    Measure = CALCULATE(SUM('Table'[Amount]),ALL('Table'[Date]))

     

     3.Final output