Gauge visual is showing the sum of of my budget table and not the actual budget.

[PeterVE]

Hi,

I tried to create a gauge visual but it is displaying the sum of my budget column and not the actual budget. Any ideas on how to fix this? The budget maximum should be 1.5m.

[v-yetao1-msft · Accepted solution]

Hi @PeterVE 

For Gauge visual , you can only put fields with Whole number type in it . In Target value , the value for field is impossible to display classified .So when you put field “Budget” in Target value , the displayed data is not your actual data in the master table, but aggregated calculations .

My suggestion is adding a slicer with “Date” from master table. And choose sum for “Budget” in Target value . 

I have attached my pbix file ,you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

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

[amitchandak]

@PeterVE , check what all column you have given, Please share those

[PeterVE]