Forum Discussion

Dineshkumar91's avatar
Dineshkumar91
New Member
2 years ago
Solved

How to create Gauge Chart with Filters.

Hi,   I have a set of data in which it has 100 rows filled with repeated names. I need to create a Gauge chart with the below condition. Please help me to get it solved as I am new to Power BI.   ...
Need Help
  • Alf94's avatar
    Alf94
    2 years ago

    Hi Dineshkumar91 ,

     

    I tried to create your model with the following data (only 10 rows but the idea remains the same):

     

     

    Here is what I can get:

     

     

    The measure I used is as follows:

     

     

    # names = 
    DIVIDE(
        COUNTROWS( 'Table' ),
        CALCULATE(
            COUNTROWS( 'Table' ),
            ALL( 'Table'[Name] )
        )
    )

     

     

    If I answered your question, please mark my post as a solution.

     

    Best,

Alf94's avatar
Alf94
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi Dineshkumar91 ,

 

I tried to create your model with the following data (only 10 rows but the idea remains the same):

 

 

Here is what I can get:

 

 

The measure I used is as follows:

 

 

# names = 
    DIVIDE(
        COUNTROWS( 'Table' ),
        CALCULATE(
            COUNTROWS( 'Table' ),
            ALL( 'Table'[Name] )
        )
    )

 

 

If I answered your question, please mark my post as a solution.

 

Best,

  • Dineshkumar91's avatar
    Dineshkumar91
    New Member
    2 years ago

    Thanks Alf94 for the solution. Cheers.