Forum Discussion
Monthly quota tracking
Newbie here... I have a powerbi report tracking my Azure costs which is working quite nicely. My Azure has several resource groups that I track separately, pulling out and graphing their usage breakdown and costs. I have a separate manual table in PowerBI listing the groups and a monthly 'target quota' value. I'd like the report to have a guage visual showing how the cost looks against the quota. The quota isn't a fixed limit. It's just to highlight if the project is heading for a higher than anticipated cost.
project A - £500 pm
project B - £100pm
I can create that table. What I can't work out is how to create the visual so that if the time period selected is say 3 months, then the quota available for that period will show as A £1500 ( quota x 3) , B £300 (quota x 3). If the time period is 2 months then quota x2 etc.
Suggestions if this is possible? Would a guage visualisation be the place to start, and how do I use calculated values for the fields?
Hi, novice99
Based on your description, I have created many measures to achieve the effect you are looking for. Following picture shows the effect of the display.
Measure:
periodQuota = VAR _months = SELECTEDVALUE ( 'Month'[Month] ) VAR _quota = SELECTEDVALUE ( 'Table'[Quota] ) VAR _periodQuota = CALCULATE ( _months * _quota ) RETURN _periodQuotaIf this does not work, could you please share some sample data without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi, novice99
Based on your description, I have created many measures to achieve the effect you are looking for. Following picture shows the effect of the display.
Measure:
periodQuota = VAR _months = SELECTEDVALUE ( 'Month'[Month] ) VAR _quota = SELECTEDVALUE ( 'Table'[Quota] ) VAR _periodQuota = CALCULATE ( _months * _quota ) RETURN _periodQuotaIf this does not work, could you please share some sample data without sensitive information and expected output.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum