Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In the viz above, the target amount is £264,100, of which £61,400 is still remaining. What I want to show is the bar with the remaining value to be greyed out and on the right hand side and the remining value (£61,400) to continue to show as it is currently. Below is how the fields list is currently laid out...and ideas??
Solved! Go to Solution.
Hi @mbrierley,
How about using 100% stacked bar instead of gauge? where the darker stack is the current standing and the lighter is the remaining portion. This can be achieved using a helper table and a measure.
Proud to be a Super User!
Hi @mbrierley,
How about using 100% stacked bar instead of gauge? where the darker stack is the current standing and the lighter is the remaining portion. This can be achieved using a helper table and a measure.
Proud to be a Super User!
That is pretty much what I need @danextian ....but is it not possible to have it in a gauge like that?
I would like to know if that is possible but right now i don't have power bi desktop with me. Also, I tend to shy away from custom visuals unless the native ones and some DAX and PQ tricks can't suffice my reporting needs.
Proud to be a Super User!
Regardless, I think that is something that I can work with, much appreciated @danextian. If you did find a way to get that done in gauge though, I'd be really interested to know how you do it 🙂
Hi @mbrierley,
I'm afraid this requirement is not achievable. To show the remaining value on the right hand of the guage which is greyed out you can add the result (total-remaining) to "Value" section. But the data label (£61,400) won't be shown.
Regards,
Yuliana Gu
Did you ever figure this out? Would love to know the solution here.
Thanks,
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |