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