Forum Discussion
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...
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
Quick suggestion:
When editing interactions, do you have the bar graph selected before changing the other interaction?
When I first started using the interaction editor sometimes the wrong visual was highlighted.