Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |