Display Gauge Visual based on Report Filters

[Anonymous]

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

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very clear. something like this

if(isblank([plan values]), [measure1], [measure2])

[Anonymous]

@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)