Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Dineshkumar91
New Member

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.

 

Condition: Value = count of filtered name / total count (i.e. 100)

 

For example: I have 100 rows with names as A, B, C, D & E which are repeatative. If count of A is 26, then value = 26/100 = 0.26, this should go as data for "Value" field while creating Gauge Chart. I will be having silcer to select the required option to know the value.

 

 

1 ACCEPTED SOLUTION
Alf94
Super User
Super User

Hi @Dineshkumar91 ,

 

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

 

Alf94_0-1695808238814.png

 

Here is what I can get:

 

Alf94_1-1695808283027.png

 

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,

View solution in original post

2 REPLIES 2
Alf94
Super User
Super User

Hi @Dineshkumar91 ,

 

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

 

Alf94_0-1695808238814.png

 

Here is what I can get:

 

Alf94_1-1695808283027.png

 

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,

Thanks @Alf94 for the solution. Cheers.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.