cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Changing Colors of my Geographies in a Matrix

Hi,

 

I have a dropdown slicer that allows users to select a "Market" A "Market" consist of 2 geographies, for example a Grocery store chain for the 1st geography and that grocery store chain's competition is the 2nd geography.

 

When the user selects the Market the 100% Stacked Bar Chart displays the % of sales of geography 1 and geography 2 with data colors of the 2 geographies being a different color. My personal theme as a Color 1 of blue and a Color 2 of green. 

 

The problem is when the user selects a total new Market the colors for both geographies change. I want the color to continue to stay the Color 1 blue and Color 2 green.

 

Here is Market 1 selection:

market 1.png

 

And when I change the slicer for Market to another market here is what it shows:

 

market 2.png

 

 

Any way to force the colors to stay the same blue/green?

5 REPLIES 5
Highlighted
Super User IX
Super User IX

Re: Changing Colors of my Geographies in a Matrix

Depends. Maybe use a disconnected table trick so that the actual categories really never change.

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Super User IX
Super User IX

Re: Changing Colors of my Geographies in a Matrix

@gmooney10 , what I observed that it associate a color with each category and then use the same when you filter. Color formatting is also not an option to change as of now.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Changing Colors of my Geographies in a Matrix

Hi @gmooney10 , 

As above mentioned, each stacked bar 's color should be same, I don't know how you design your chart, so if possible, could you please inform me more detailed information (such as your sample data and your expected output and your chart setting or your pbix file)?

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

Highlighted
Helper V
Helper V

Re: Changing Colors of my Geographies in a Matrix

Hi @dax , My pbix is a large file (143meg). How can I mask the data or prepare the file to share?

Highlighted
Community Support
Community Support

Re: Changing Colors of my Geographies in a Matrix

Hi @gmooney10 , 

I don't need your real data, you could just use virtual data(simple data) and create chart like your above shown, then upload the pbix file.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors