Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have a Table visualization that shows customers and revenue with filter of "In Current Year". On the same page, I have a Bar Chart visualization showing revenue over the past 12 months. What I would like is when a user clicks on an individual customer in the Table, the bar chart keeps the "past 12 months" filter while showing data only for that customer. Currently, the bar chart also assumes the "In Current Year" filter when a customer is selected, which I do not want to happen.
Is this possible to achieve?
Solved! Go to Solution.
@AV155 , If current is because of filter or slicer, it will pass the value. Try to create a measure for the current year then it should only pass customer
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
@AV155 , If current is because of filter or slicer, it will pass the value. Try to create a measure for the current year then it should only pass customer
example
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
That makes sense. I should have thought about making measures to accomplish this. Thanks!!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |