Multiple variables in a stacked column chart in powerbi

[mike9191]

Hello, I would like to create a graphic with 4 variables::

1. Number of people (#)

2. Time, i.e., "1st quarter", "2nd quarter", "3rd quarter" and "4th quarter"

2.1 Within each quarter there would be 3 buckets, i.e., "Bucket 1", "Bucket 2" and "Bucket 3".

2.1.1 Every bucket within all quarters would be a column divided into 3 categories (like stacked bars): "Orange", "Yellow" and "Green".

Below you can find a draft of the graph 🙂

I appreaciate any hint. 

[amitchandak · Accepted solution]

@mike9191 , You can not use conditional formatting in stacked visual as of now.

With your AXIS display seem like you do not need the stacked. You need two axis clustered visual with concatenate label off and conditional formatting. You will not have stacked in that case

if yes

refer the power bi part in this

Tableau Vs Power BI- Chapter 4- Bar/Clustered Bar: https://youtu.be/2P5BBRN853c

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4