Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I was wondering if there is a way to show a static line in a chart(line and clustered column chart) that's filtered by a Calendar(using a slicer). I have tried creating another measure linked to a second calendar, but the filter still affects both lines. The idea is to use it as the "total" line, to compare it with the progress for the range of dates specified by the Slicer.
Is there any way to do it?
Thank you in advance.
Sounds like you need to put an ALL in your measure calculation. Hard to say though.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |