Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Is there a way to make just the line in a line and stacked column chart not dependent on slicers? I want to compare data against the total average, not what is sliced.
When I filter down, it recalculates to the average within those filters.
Solved! Go to Solution.
@Anonymous
For the line, i suggest you create a measure (not column) and in the formula use the ALL, ALLSELECTED functions so as to ignore slicers.
A good link is the following:
https://www.sqlbi.com/blog/marco/2010/04/05/all-allexcept-and-values-in-dax/
Then add this measure to the graph
@Anonymous
For the line, i suggest you create a measure (not column) and in the formula use the ALL, ALLSELECTED functions so as to ignore slicers.
A good link is the following:
https://www.sqlbi.com/blog/marco/2010/04/05/all-allexcept-and-values-in-dax/
Then add this measure to the graph
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |