Forum Discussion

bw70316's avatar
bw70316
Icon for Helper V rankHelper V
7 years ago

View Gauge as Bar Chart

I am trying to highlight the amount of the budget spent so far this year. I have my current amount spent vs. my original budget. I am attempting to create a bar chart where the bar is equal to the su...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi bw70316,

 

Maybe you can use Line and stacked column chart or Line and clustered column chart to work around. Here I made one sample for your reference. If it doesn't meet your requirement, kindly share your sample data to me.

 

A = CALCULATE(SUM(Table1[sales]),FILTER(Table1,Table1[type]="A") )
B = CALCULATE(SUM(Table1[sales]),FILTER(Table1,Table1[type]="B"))

 

For more details, please check the pbix as attached.

 

Regards,

Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi bw70316,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.

 

Regards,
Frank