How to do this in POWER BI?

[drrai66]

Hello Everyone,

I need to Convert the following view created in Tableau to be converted into POWER BI. How can I achieve same view?

Thanks

Deepak

[parry2k · Accepted solution]

drop clustered bar chart and drop your category, sub category, manufacturer on x axis, drop sales in value and use aggregated method sum.

drill down to in line hiearchary 

or use column chart, repeat above step , go to format tab, and under x axis , turn of concatenate labels. (this option is not available in clustered chart)

[parry2k · Accepted solution]

i guess you can try by going to field formatting -> choose sales column and set alignment to "center" or right

[parry2k · Accepted solution]

drop clustered bar chart and drop your category, sub category, manufacturer on x axis, drop sales in value and use aggregated method sum.

drill down to in line hiearchary 

or use column chart, repeat above step , go to format tab, and under x axis , turn of concatenate labels. (this option is not available in clustered chart)

[drrai66]

I used your 2nd Approach like this, So this is what I get.

For my case I would prefer to use stacked bar, as it looks similar to what I have in Tableau,Can we format the following chart Someway to get Similar to Tableau.

[parry2k]

Unfortuantely not, clustered chart doesn't have concatenation option 😞

vote for an idea if it is already there or create new one.

[drrai66]

Ok thanks a lot..I would accept your initial solution.

[Vvelarde]

@drrai66

One way to simulate this is with a Matrix with Data Bars

Regards

Victor

[drrai66]

Hi Victor,

Yes, can you explain the Steps.

Thanks

Deepak

[parry2k]

create matrix visual, drop Category/Sub Category/Manufactures on Rows and Sales on Values, similar thing, drill down and turn off step layout off 

in arrow next to sales -> click down arrow, click conditional formatting -> Data Bars, in popup windows., check Show Bar Only

turn off totals.

[Vvelarde]

@drrai66

-Insert a Matrix with the fields in the previous reply

- Go to Lowest Level of Data (Image with The two arrows connected )

-Go to Format Panel:

Row Headers- Stepped Layout OFF

 SubTotals --Row SubTotals - OFF

After that in Fields Panel in the visual :

Select Sales (in Values Section) - Conditional Formating - Data Bars --Ok

I hope that was clear. 😃

Regards

Victor

[drrai66]

Thank you both Victor and Parry. I got it. Is their a way to write values on the bars also.?How Can I write Values on Each Bar?

Thanks

Deepak

[parry2k]

I mentioned to check "show bar only", if you uncheck that it will show values.

[drrai66]

Yes Got it, Is there a way I can put each Value on to the bar, Right Now they are at the Top, Is there any Alignment thing for this too?

Thanks a lot

Deepak

[parry2k · Accepted solution]

i guess you can try by going to field formatting -> choose sales column and set alignment to "center" or right

[drrai66]

It Worked, One more thing, Can I Color the Bars Depending upon Total Sales.

Thanks

Deepak

[parry2k]

what you mean?

[drrai66]

I mean to say Right now all the bars have different weights depending upon sales and they are all in one color. Can we do something like this, so that BIG Bars with BIG Sales are in different Color.

Like this

or Like this

Thanks a lot

Deepak

[parry2k · Accepted solution]

As far as I know, not possible, there is no rule based color selection at this point for data bars.

if it is was clustered visual then you had the option to use "Color Saturation"

[drrai66]

Thanks Again

Deepak