Re: gauge middle number doesn't change

iamblue91 · ‎07-26-2017

Hello all!

I am trying to use the gauge visual to show the amount of a budget reamining (or budget spent if you like).

I've created a new table following this website: https://pbidax.wordpress.com/2016/06/03/connect-any-number-of-tables-together-via-a-common-column/

I'm having issues having the middle number change to either amount of budget spent. Any guidance would be greatly appreaciated!

Happy to provide some screen shots of the tables!

Eric_Zhang · ‎07-28-2017

@iamblue91 wrote:

Hello all!

I am trying to use the gauge visual to show the amount of a budget reamining (or budget spent if you like).

I've created a new table following this website: https://pbidax.wordpress.com/2016/06/03/connect-any-number-of-tables-together-via-a-common-column/

I'm having issues having the middle number change to either amount of budget spent. Any guidance would be greatly appreaciated!

Happy to provide some screen shots of the tables!

@iamblue91

What do you mean middle number change, could you post some sample data and expected output?

iamblue91 · ‎07-30-2017

Hi @Eric_Zhang

Sorry about that.

I think (I'm still learning the lingo) it's the 'Value' No matter what filter I apply on the slicer, the 'value' doesn't change from $30.38K. The maximum value changes, however.

Eric_Zhang · ‎08-01-2017

@iamblue91 wrote:

Hi @Eric_Zhang

Sorry about that.

I think (I'm still learning the lingo) it's the 'Value' No matter what filter I apply on the slicer, the 'value' doesn't change from $30.38K. The maximum value changes, however.

@iamblue91

What is the measure Total Biilable like? Is it related to the data in the slicer?

For further investigating, could you share the pbix file? You could upload it in a network drive(Onedrive, Googledrive etc) and share the link. Do remember to mask sensitive data beforing uploading.