Multiple stacked column chart

[Anonymous]

Hi All,

I am facing diffculties in creating Multiple stacked column chart  for Weekly and YTD. Is there any workout to acheive like below chart

[TomMartens]

Hey @Anonymous ,

unfortunately, this kind of visual is not supported at the moment.

But maybe you can create your own visual using Charticulator: https://charticulator.com/

Regards,

Tom

[Anonymous]

@TomMartens  Is there any other option available in PBI to acheive this kind of reporting.

OR

can i show my YTD bar in different color

[TomMartens]

Hey @Anonymous ,

you can control the fill color of a column/bar by using conditional formatting.

To change the color of the columns from this:

 to this

I created this measure:

Measure 2 = 
var _category = MAX('Dimension Customer'[Category])
var fillColor = IF(_category = "N/A" , "red" , "#808782")
return
fillColor

What the measure does is this:

It reads the current value of the column Category by using the MAX(...) function. The column is used as inner axis-label.

If the current value equals "N/A" then the color "red" should be used, otherwise a hexcode.

I applied the measure for the conditional formatting by changing the data colors option of the chart:

Hopefully, this provides what you are looking for.

Regards,

Tom

[Anonymous]

@TomMartens 

I have created the measure, but its not allowing me to drop in axis or legend.

[TomMartens]

Hey @Anonymous ,

you can't use the measure as legend or axis.

You have to change the Data colors formatting option of the chart, see the screenshots inside my previous answer.

Regards,

Tom

[Anonymous]

@TomMartens  Unable to see default data color

May be i am using differnet chart. can i share my pbix file

[TomMartens]

Hey @Anonymous ,

you are right, this seems to be related to using a column at the legend.

I recommend that you file an idea ideas.powerbi.com

Regards,

Tom