Forum Discussion

luqmaanr's avatar
luqmaanr
Frequent Visitor
6 years ago

Gauge

I have 3 sets of Data:

Set 1 = # of Items that are 1 week Late

Set 2 = # of items that are 2 - 4 Weeks Late

Set 3 - # of items that are 30 days + Late

 

I want to represent these data in a Gauge type visualization for e.g:

Set 1 = Green Color

Set 2 = Yellow Color

Set 3 = Red Color

 and having trouble with all the types of gauges (Tachometer, Rainbow, linear) that exists. Please advise on which visualizato

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    If i were you i would reconsider the chosen visual. Gauges are not made for showing 3 numbers of items. Gauges are used to show progress. a goal and the situation as it is. For example sales. if i want to sell 500 bikes in feb 2020 i can show the amount of bikes sold since 1 feb till today. And i can set the goal to 500. A gauge is perfect good for showing those kind of numbers. 

     

    For your situation i would just use a bargraph showing the 3 bars. Those bars you can color the way you like.

    • luqmaanr's avatar
      luqmaanr
      Frequent Visitor
      6 years ago

      thanks for your response Eric, on a main dashboard page the bargraph will not represent well. When I drill through it goes to a bar graph but the tachometer or any other gauges will represent the data in a professional ways. that's why I want to use any gauges.

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    I advise you to use 'Line Chart' visual.

    Please try these three measures:

    1 week late = CALCULATE(SUM('Table'[Item Sales]),FILTER('Table','Table'[Date]>=TODAY()&&'Table'[Date]<DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+7)))
    2-4 week late = CALCULATE(SUM('Table'[Item Sales]),FILTER('Table','Table'[Date]>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+14)&&'Table'[Date]<DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+28)))
    30+ days late = CALCULATE(SUM('Table'[Item Sales]),FILTER('Table','Table'[Date]>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())+30)))

    And it shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

    • luqmaanr's avatar
      luqmaanr
      Frequent Visitor
      6 years ago

      Hi Giotto,

      Thanks for your response and much appreciated. I have the measures and was looking to use any type of Gauges to represent the lateness of each items.

      50 Items late by 1 week

      111 Items late by 2 - 4 weeks

      126 Items late by 30 Days +

      Something like in this screenshot: