Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Is it possible to deactivate parts of cross filtering logic? The problem: In a matrix table, there are several columns with monthly data. and there are several rows of data. In this test example three contintents, drillable down to countries and cities.
This data is also displayed in a line chart.
What I want is a matrix, which only displays data from latest month (here May), but in the line chart with all month's data on x-axis (here March to May). Using a normal crossdrill results in displaying only the data for the last month, which is filtered and displayed in the matrix table. So there is just one data point in line chart.
I've tested some dax logic using the calculate function with ALL parameter which should ignore /deactivate any filters.
Amount Test All = CALCULATE(SUM(test_crossfilter[Amount]);All(test_crossfilter))
However this does not work.
Any ideas?
Thanks....
You may try adding measures to Visual level filters.
Hello Sam,
thanks for your proposal. Maybe I didn't understand it correctly. What I've done so far with visual level filters is a filter on matrix to display only current month's data. (relative date filtering). The line chart has no visual filter on date. Every month should be displaye.
But this results in the described problem. Crossfiltering it results just in May's data (of course).
What is meant with "measures" in your reply?
There must be some DAX solution to allow crossfiltering on only one dimension (here: Continent) and ignore another (here: date_month).
Thanks, Matthias
Hi there, have you found a solutionf for this? I've been struggling to find a solution to this filter behaviour as well.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |