cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zilaifeng Frequent Visitor
Frequent Visitor

Slicer on combo chart

Hi,

Say if I have a combo chart with line and bars, is there a way to put a slicer so that I can choose to view line only, bars only, or both?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Slicer on combo chart

You can, but it takes a little work. The easiest way would be with butons and bookmarks. 

I reccomend you read the links in this reply.

 

Duplicate the graph three times, one with just lines, one with bars, one with both.

Hide two graphs. Open the selection pane and highlight the three graphs.

bc.png

 

 

 

 

 

 

 

 

 

then record a bookmark with just one graph visable. Rename the bookmark the same as the visable graph. 

Repeat for all three.

Under bookmark settings, open the slipsis and select only "Disaply" and "Selected Visuals":d.png

 

 

 

 

 

 

 

 

 

Nowe, make three buttons by home tab > insert > button > blank. Under the Action field in their properties select bookmar, and select the column bookmark. Under button text, you can write column only. Repeat for line and both.

 

Now, selecting the buttons will show the desired output (hold CONTROL and click if you are in the desktop).



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



View solution in original post

2 REPLIES 2
Super User I
Super User I

Re: Slicer on combo chart

You can, but it takes a little work. The easiest way would be with butons and bookmarks. 

I reccomend you read the links in this reply.

 

Duplicate the graph three times, one with just lines, one with bars, one with both.

Hide two graphs. Open the selection pane and highlight the three graphs.

bc.png

 

 

 

 

 

 

 

 

 

then record a bookmark with just one graph visable. Rename the bookmark the same as the visable graph. 

Repeat for all three.

Under bookmark settings, open the slipsis and select only "Disaply" and "Selected Visuals":d.png

 

 

 

 

 

 

 

 

 

Nowe, make three buttons by home tab > insert > button > blank. Under the Action field in their properties select bookmar, and select the column bookmark. Under button text, you can write column only. Repeat for line and both.

 

Now, selecting the buttons will show the desired output (hold CONTROL and click if you are in the desktop).



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



View solution in original post

Super User I
Super User I

Re: Slicer on combo chart

The other way, is to make a slicer table:

 

Home > Enter Data > add "Line" and "Bars", call it "FilterTable" and click load.

b.png

 

 

Now, add two measures:

Bars = if( "Bars" in VALUES(FilterTable[Value]),
    <<Your Column Measure>>
    BLANK()
)

Line= if( "Line" in VALUES(FilterTable[Value]),
    <<Your Line Measure>>
    BLANK()
)

Add "Lines" measure to the line value and "Bars" masure to the column value.

 

You can add the FilterTable[Value] column as a slicer, and toggle on and off the bars and line.

 

 



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png



Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors