topic Re: Matrix in Stack Column chart in Developer

Matrix in Stack Column chart

Anonymous — Tue, 28 Sep 2021 15:18:35 GMT

Hi,

I tried to show the stack column chart in matrix view which is possible in tableau but I am not able to do it in Power Bi.

How to show Stack bar chart in Matrix view in Power BI ?

Mainly I need to see two values in one cell like in stack column chart

In the above image I tried to convert to single matrix view like if you see the Name 10 and value 10 I need to see the countsof A and B in Single cell as stack column chart.

Re: Matrix in Stack Column chart

Anonymous — Fri, 01 Oct 2021 02:35:46 GMT

Hi @Anonymous ,

You can refer the solution in the following threads as a workaround to implement it:

1. Multiple Values for a Matrix can now Appear as Row Headers

2. Turning multiple values into one string in Power BI (If the matrix values are Text type)

If the above ones can't help you get the expected result, please provide some original sample data in your tables and your expected result with the formula of involved measure/calculated column and special examples. Thank you.

Best Regards

Re: Matrix in Stack Column chart

Anonymous — Mon, 04 Oct 2021 10:51:12 GMT

Hi @Anonymous

No this is not a solution I have two different measure which we need to show to one cell like a stack column chart with different colours.

Re: Matrix in Stack Column chart

Anonymous — Tue, 05 Oct 2021 09:59:41 GMT

Hi @Anonymous,

Based on my research, I'm afraid that your requirement (display two field values in one cell cell of the stacked column visual with different colors) is not possible. You can raise a new idea and add your comments there to make this feature coming sooner.

Best Regards

Re: Matrix in Stack Column chart

mvernoy — Sat, 25 Feb 2023 17:26:47 GMT

Greetings ... I have been scouring the forum and web to find a solution for this as well. Since our hospital switched from Tableau to BI recently I have been porting dashboards over. I have run in to one issue like the topic above and was wondering if there has been a solution to this since 2021?

Below is the visual I want to re-create but with three stacks:

Tableau

And this is the common relationship in BI for the visual that I am jtrying to build:

The fields in which I want to stack are in the future appointment table are:

Appt_booked_loaded | Appt_Unbooked_loaded | Appt_Block

I have got to this point below:

I have tried multiple ways to get a stacked bar into the cells for each clinician under the date column header but have not reached the desired end state.

Any help is truly appreciated, Have a great day.

Mark