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
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.

Highlighted
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
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 136 members 1,594 guests
Please welcome our newest community members: