Forum Discussion

ninky1982's avatar
ninky1982
Advocate I
8 years ago
Solved

Using percentage in a guage

Can't get my head around this...   What I want to do is create a percentage guage of the 256 over total records 2300.  The percentage should work out at about 11% and I want this 11% to be shown as...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Have you worked out which visual you would like to use?

 

On the "From Store" button you can get access to some extra visuals, one called a Tachometer should achieve what you are attempting.

 

To achieve that, after downloading the visual, you would simply need to:

  • Create a measure that simply returns count when BHLD Y/N Flag = yes.  I have put an example below
  • Place the measure in Value box
  • Place [Order] column into End Value and set as count
  • Create a measure to calculate your Target value, which you have indicated is 8% in this example.  I don't know how you arrive at 8% so hopefully its easy for you to create.
Y Flag Count = CALCULATE(
	CountRows ('YourTable'[Order]),
	'YourTable'[BHLD Y/N Flag] = "Y"
)

 

  • ninky1982's avatar
    ninky1982
    Advocate I
    8 years ago

    Thanks so much I'll look at the Tachometer and may be it's a good/better way!