Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Show hide guage

Hi In my data sheet I have  Column A: Sales person Column B: Region  Column C: sales   Each sales person has between 1 and 3 Regions   I have created a slicer for Sales Person and 3 guages. G...
Need Help
Tips and Tricks
v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Please try these measures to show your sales and forecast sales in three tables.

Here is an example for one table(Filtered by region=A):

Sales-A = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Region]="A"))
Forecast sales-A = CALCULATE(SUM('Table'[Forecast sales]),FILTER('Table','Table'[Region]="A"))

And when you select a sclier value to filter, it shows the blank not 'no data':

And remember that you should create another four measures for other regions.

Hope this helps.

 

Best Regards,

Giotto Zhi

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks v-gizhi-msft  for this

 

This shows the A headings still

 

Also I'm using guages not tables

 

My understanding is that using this formula the guage would still be there even if there was no data

 

Am I correct in thinking that? if so, how to not show anything if there is no data?

 

In other words - show 3 gauages if 3 regions, show 2 guages if 2 regions, 1 guage if 1 region?

 

Thanks