cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
td_beginner
Helper I
Helper I

Have Columns as selection to show on visual

Hello, 

    In my dataset, I have 2 fields "Total Charges", & "Unique Roamers":

td_beginner_0-1627582310883.png

    In my 100% Stacked Column Chart, I show both the fields as Values for each Country:

td_beginner_1-1627582489036.png

 

         I want to have a selection to show only  "Total Charges", or "Unique Roamers", or both by default.

 

         Since they both are not values of a field, I don't think Slicer can work. 

         Can I have something like a toggle button or some way of selection and reflect that in the chart i.e. Show only "Total Charges", or "Unique Roamers", or both if none is selected.

 

         How can I accomplish this ?

         Thanks for any help.

 

1 ACCEPTED SOLUTION

@td_beginner 

Hope this video will help you understand the concept : 

https://www.youtube.com/watch?v=_HTF7Ph7Eqc

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

4 REPLIES 4
Fowmy
Super User IV
Super User IV

@td_beginner 

If you select one field then you will see 100% for all the countries, I am not sure what is the purpose of a 100% stacked column chart. 

You can create 3 Bookmarks where you will create three charts with each scenario

.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thanks @Fowmy Actually, I wasn't able to add both values; it worked using 100% Column chart, so I went with that. 

Yes you are right, if I want ot change it to single column, it shouldn't be 100% col chart. I am not restricted to use 100% col chart. 

 

What do you mean by bookmarks for each scenario ?

@td_beginner 

Hope this video will help you understand the concept : 

https://www.youtube.com/watch?v=_HTF7Ph7Eqc

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

 

This is a nice way, @Fowmy Thanks for sharing this new concept.

 

I am concerned about 2 things with this concept:

1. Always I would be having 3 charts loaded with data (though only 1 will be visible). If so,  would this affect the performance ?

2. When any of the other chart is shown, will it load data based on any slicers selected ?

 

Can you help with my concerns?

Do you see any other solution or way to achieve this?

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors