cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maheshrakwal Frequent Visitor
Frequent Visitor

Bar chart for 3 different measures over one dimension

Hi All

 

The below chart is designed on Tableau and i want to replicate this chart in Power BI. Can someone sugest me how to achieve this on Power BI.

 

These 3 are the calculations (Measures)

1. Previous Year Sales

2. Inventory

3. Placed Orders

 

Need to display them as bars based on one dimension and further want to segregate these bars (in color) based on one dimension (Lane).

 

Tableau Visual : 

 

Tableau.PNGThis is Tableau visual, Need to replicate in Power BI

3 REPLIES 3
Highlighted
Thejeswar Senior Member
Senior Member

Re: Bar chart for 3 different measures over one dimension

Hi @maheshrakwal,

Something like the one that you showed is directly not possible (i.e. Similar to the way in tableau).

 

But you can achieve it using three different chart one below the other with the same category axis column in all the 3 visuals

It also requires some formatting modifications like hiding x axis in the visuals wherever not required and displaying Y Axis Title in the visuals and other minor formatting changes as per your need.

 

Essentially after making all the changes, your visual should look like the one below (You can also do much more modifications, if possible to make it look closer to your existing visual in Tableau)

visual.PNG

 

 

This Approach will be best if there is always data available for all the entries in your category. Otherwise says 2 of the charts have dta and one does not have data, the categories might mismatch

leharkapil Member
Member

Re: Bar chart for 3 different measures over one dimension

Hi Thejeswar,

 

 

We want all the bars in single chart. Tableau has this functionality but unfortunately it seems powerbi lacks this.

Never mind, if there is some custom visual wich you can suggest, that would be helpful.

SureshPantra Regular Visitor
Regular Visitor

Re: Bar chart for 3 different measures over one dimension

Can you please explain how to create that visual.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors