Forum Discussion
Display Gauge Visual based on Report Filters
Hi All,
I have a requirment like below.
As you can see below I have Actual vs Plan data for 5 countries. (Blue bar- Actual , Black Vertical bar - Plan)
Based on this there is a Gaude Bar visual which shows the Pecentage values . (Formula : Actual / Plan)
The First requiremet is
1. Show the Gauge bar value only when there is Actual and Plan values for all 5 countries , else Blank. This I was able to achieve using some IF ELSE logic. The Gauge Bar will lokk like the below in this case.
Iam facing challenge in implementing the 2nd requirment on top of this . The 2nd req is
2. We have country ID as page filter (which by default Selects and shows all 5 countries). Whenver users unselects the countries that are not having actual or plan values , the Gauge bar should show the calculated value.
For Ex: Here, country GCL and GVL are not having plan values. So, if the user unselects both these countries from Filter pane, we are left with 3 countries that are having both Actual and Plan Values. In that case, the gauge visual should show the corresponding calculate value , like (sum of Actual values for 3 countries /sum of plan values for 3 countries).
is there a way to implement this together. Requesting suggestions
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
Anonymous , Not very clear. something like this
if(isblank([plan values]), [measure1], [measure2])
- AnonymousNot applicable
amitchandak there is only one measure for Gauge visual ( Division of actual and Plan - Actual/Plan). The first requirement i could achieve using IF ISBLANK condition. But my challenge is another scnario on top of this When the user selects only the countries having both actual and plan values (from the filter pane), the gauge bar that was showing blank should show the calculated value (as shown in the last pic)
- v-lionel-msft
Community Support
Hi Anonymous ,
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.