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
Anonymous
Not applicable

Fillable column in barchart

Hello, guys!

Is it possible to do the same in PBI ? 

Left bar - last year (forecast  70,3 + fact measures 71,5)

Right bar - current year (forecast 74,8 + fact measures 71,5)

 X asis - months

There is Excel column chart throught overlapping axis.q.PNG

Sample data:

Month2019_for2019_fact2020_for2020_fact
Jan70,371,574,871,5
Feb69,971,474,773,3
Mar69,971,376,273,5
Apr69,470,177,449,3
1 ACCEPTED SOLUTION

Hello @KonstantinD

Use this link to find a file:

https://file.io/vDcAnEJdObtq

_______________
If I helped, please accept the solution and give congratulations! 😀

View solution in original post

18 REPLIES 18
amitchandak
Super User
Super User

@Anonymous , You have used stacked chart visual for that

Anonymous
Not applicable

Thanks @amitchandak , hovewer Im not sure it possible. Could our share the link with the decision ?

lkalawski
Memorable Member
Memorable Member

Hi @Anonymous

 

Yes, you can use Stacked Bar chart with Legend.

 

To have a different measure on the left and a different measure on the right, you must write the appropriate measure for this.
Provide sample data, or upload a file without private data.  

 

Please check this: https://www.tutorialgateway.org/power-bi-stacked-bar-chart/

 



_______________
If I helped, please accept the solution and give kudos! 😀

 
Anonymous
Not applicable

Hey, @lkalawski 

Its not stacked bar, unfortunately.

There are two  overlaped charts.

 

Hi @Anonymous 

Ok, could you please upload some sample data to create a chart or a .pbix file? I'll try to create a similar chart.



_______________
If I helped, please accept the solution and give kudos! 😀

Anonymous
Not applicable

Thanks @lkalawski  for your kind attention!

Added some sample data in the header.

@Anonymous

If you want to do it on one chart, I can only suggest this solution:

Ex1.png


Unfortunately, it cannot be set otherwise.

Possibly a combination of two graphs.



_______________
If I helped, please accept the solution and give kudos! 😀

Anonymous
Not applicable

Thank you, @lkalawski !

But we lost 2019 forecast  + fact.

It should be able to visual all 4 measures on 1 chart.

@Anonymous 

On the picture you can find forecast + fact for 2019, please check the labels. Jan 2019 and Jan 2020 (on the bottom you have fact value, on the top forecast). 



_______________
If I helped, please accept the solution and give kudos! 😀

Anonymous
Not applicable

Oh! Soryy, @lkalawski - got it.

COuld you please share pbx ? 

Hello @KonstantinD

Use this link to find a file:

https://file.io/vDcAnEJdObtq

_______________
If I helped, please accept the solution and give congratulations! 😀

Anonymous
Not applicable

Many thsnks @lkalawski

Anonymous
Not applicable

same @lkalawski  )

404

 

could you please add pbix to the message ?

@Anonymous

As I know, we can't add files directly to the message. Correct me if I'm wrong.

 

I'm afraid I have lost this file because it has expired. I will try to create it today again and send you a link.

 


______________
If I helped, please accept the solution and give kudos! 😀

Anonymous
Not applicable

Thank you so much @lkalawski !

Hi @Anonymous 

 

Please check this link: https://file.io/acp97HHdNhyJ


_______________
If I helped, please accept the solution and give kudos! 😀

Anonymous
Not applicable

Yeah! Thats it!

Many thanks @lkalawski !

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.