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...
Need Help
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: