Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a tooltip page linked to a Map view. The map view is filtered by year using a slicer. (this is a numeric dimension, not coming from a date).
All my data comes from a tabular analysys services database.
Inside the tooltip, I have two visuals, a Line chart and a multi-row card.
I've tried following what is recommended in this thread, and it works for the whole tooltip page. In other words, if I turn off "keep all filters" and filter only by the country name, I can see the multi-year view in the chart, but the values in the card shows also the multi-year sum of values.
If I turn on "Keep all filters", I cannot find the way to show the multi-year view of the data in the chart, but the values in the card shows the correct one-year values for the year selected.
Vs:
Any help will be greately apreciated.
Something to try. Make a new measure specifically for your line chart and in it enclose whatever formula returns your data with this following DAX Calculate logic:
Amount_TTLineChart = Calculate(YOURFORMULA, RemoveFilters('DATETABLE'[Year]))
Then what you can do is put this measure on your line chart and use your existing formula/measure for the things you want filtered. Then keep "Keep All Filters"
User | Count |
---|---|
88 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
91 | |
74 | |
68 | |
63 |