Area Chart with multiple values, but one of them is much larger than the other two.

[sharpedogs]

I have the below data set and I wnat to show it on a single graph. Althoguth the minutes numbers are in millions and the rest are in thousands, I want them all on the same graph to show that the numbers have all ben increasing together. 

There must be some way to scale the numbers? 

Week	Active Hosts	Meetings	Minutes
Feb 24	15,900	67,000	10,400,000
Mar 2	20,000	77,000	11,000,000
Mar 9	22,500	87,000	12,000,000

[mihart]

Hi @sharpedogs ,

What about using a chart with dual axes.  The left axis could show thousands and the right axis could show millions.  That way you could see all data on same visual and clearly see the matching trends. 

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

When to use a Combo chart

Combo charts are a great choice:

• when you have a line chart and a column chart with the same X axis.
• to compare multiple measures with different value ranges.
• to illustrate the correlation between two measures in one visualization.
• to check whether one measure meet the target which is defined by another measure
• to conserve canvas space.

HTH,

Michele

[sharpedogs]

After i asked the question i downloaded a newer version and it had the dual axis... great feature..

[MFelix]

Hi @sharpedogs ,

Depending on the scaling I would create a measure to calculate the minutes i the scale you want something similar to:

Minutes totals = SUM(Table[Minutes]) / 1000

The use this as my values in the chart and not the original column.

[sharpedogs · Accepted solution]

Thanks, thats not a bad solution. But I needed to keep the data points. I downloaded the new version of PowerBi and it was my lucky day.... they added the abiltity to do a second Y axis.