cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

Gauge chart for each serial number

hi, Gauge chart seems to be cool if I could display each machine's fuel remaining % level.

forex, I have a table, like below,

 

S/N  Fu.Rem%

1          100

2           60

3           20

4             3

5           72

 

I want to make 5 different gauges displaying each S/N's remainign fuel level. I made 5 gauges and tried to

filter by S/N on each gauge but the filter condition is applied to all gauges, I can't apply different filter condition

to each gauge. How can I make this?

(In addition to it, if the gauge color can be switched by the remaining level that'll be awsome, ex, less than 20%=Red)

 

would anyone help this please.

 

thank you.

 

 

3 REPLIES 3
v-yuta-msft
Community Support
Community Support

Hi TDNoz,

 

Are you using slicer or visual level filter to filter the chart? Could you share some details about your issue. In addtion,  You said "if the gauge color can be switched by the remaining level that'll be awsome, ex, less than 20%=Red", this can be achieved by setting conditional format.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

hi Jimm thanks for your reply.

 

here's example data. such a simple table.

I want to display their daily fuel remain level transission by line chart and

each S/N latest fuel remain level in each gauges.

 

I have several troubles actually,

 

Line charts

X axis in line chart.  by choosing "day" only in Date hierarchy, I could make it displayin by date

but better show month and year as well however no need time. how can I do this? 

 

Guages,

I don't know how I can make the gauges displaying each S/N's latest fuel remain level. 

moreover I do not have such conditional formatting option to have the gauge in red when

less than 20% of fuel level.

 

thank you for your help!

data.jpgcharts.jpg

 

 

 

 

Anonymous
Not applicable

Any body has any idea?

 

thanks.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors