Hello,
I noticed that in Line-and-Column graph, the X-Axis adusts to the columns and not to the line (if a field or measure is selected for columns).
Example:
I have the following dataset:
date type amount
1-Jan-2022 Bills 100
1-Jan-2022 Total 100
1-Feb-2022 Bills 200
1-Feb-2022 Coins 300
1-Feb-2022 Total 500
1-Mar-2022 Bills 400
1-Mar-2022 Coins 500
1-Mar-2022 Total 900
I build 2 measures:
BillsOrCoin=CALCULATE(SUM('Table'[amount]),type<>"TOTAL")
Totals=CALCULATE(SUM('Table'[amount]),type="TOTAL")
I create the column and line graph:
X-axis: 'Table'[date]
Column y-axis: [BillsOrCoins]
Line y-axis: [Totals]
Column legend: 'Table'[type]
I see data for Jan-Mar
I filter to see type in {Coins, Total}
I see data only for Feb-Mar (although Total has value for Jan)
I filter to see type=Total
I see a blank graph (although Total has data)
I remove the type field from the column y-axis bucket:
I see the Totals line for Jan-Mar (because when there is no column bucket, it doesn't limit the line x-axis).
I would expect that if the line bucket has x-axis values missing from the column bucket, it would still show them.
What do you think?
Reagards,
Barak
