Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
barakb321
Frequent Visitor

Line and Column Graph - Strange Behavior of Line

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

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.