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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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