In stacked bar chart, Low-level groups do not need to be displayed but do not affect statistics

[LeiKong]

Hello experts,

At present, when I set the stacked bar chart, the customer asked me not to display -V, -E,-D when setting small departments, and it could not affect the statistics of the upper large departments, How can I achieve this requirement? Please see the corresponding screenshot for details. If it cannot be achieved, are there other visualization plug-ins that can have this function ? Please provide appropriate suggestions. Thanks.

[LeiKong]

Thanks all for patient reply.  In my opinion, MDX could work in such situation. But I don't determine whether it could be achieved or not in Power BI.

[Anonymous]

Hi @LeiKong

Thanks for using the Microsoft Fabric Community.

Based on your question, we can simplify this in two ways:
Method 1: Use basic selection in filters pane and uncheck the options, as shown in the image below for reference.

Method 2: Use Groups to combine the values of D, E, and V into a single bar. To create the group, right-click on the data column (Charge) and select New Group.

Then, group D, E, and V together as one, and keep the remaining fields as individual groups. Similarly, like below image.

Drag and drop newly created groups column in Y axis.

This is how the final visual looks like after creating groups.

Please let me know if you have any more queries.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Thanks and Regards,

Vinay Pabbu

[LeiKong]

Thanks for you reply. 

For the first method,  it doesn't meet my mind.  Well, I type some records as show below.

DepartMentFirst	DepartMentSecond
D S	CN-D
Infotainment	CN-E
Validation	CN-V

When I count the dimension value "D S",  the data of the value "CN-D"  are also included to be counted.

For the second method, it deviates from my needs, they all have their own group.

[Anonymous]

Hi @LeiKong,

Is this the expected output?

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to give "Kudos" 

[LeiKong]

Hi Vinay,

Thanks for you reply.  Your mind come up with how to express my requirements.  Here is my expected output.

Best Regards,

Ricky

[Anonymous · Accepted solution]

Hi @LeiKong,

Unfortunately, it doesn't work in Power BI based on the data and context you've provided. The data and context do not align with a clear pattern for generating the expected output using

Power BI.

Please let me know if you have any other queries.

Regards

Vinay Pabbu

[Anonymous]

Hi @LeiKong ,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If my response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.

If you have any additional queries, please reach out to me.
Thank you for being a part of the Microsoft Fabric Community Forum!

[Tahreem24]

Hi @LeiKong 

You can either exclude the -V, -E,-D from  filter pane.

or you can set the sales value greater than or equal to 32%.

I hope I answered your question!

[LeiKong]

Thanks for you reply.

Well, you idea doesn't meet my requirements.  I type some records with structure as shown below. 

DepartMentFirst	DepartMentSecond
D S	CN-D
Infotainment	CN-E
Validation	CN-V

When I count dimension value “D S”, I need to include the value "CN-D" for the statistics. If I use your solution,  the dimension value "CN-D" can't be counted in dimension value “D S”.