Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to Solution.
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,
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,
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!