How to hide / unhide series of data on the chart?

[PawelNie]

Dear Community,

I am struggling how to easy hide some series of data on the chart. Is there any possibility to do that by using some fragmentation or filters?

   

 -->  

Regards

Paweł

[MNedix · Accepted solution]

I'm a bit confused, what is stopping you not adding those measures to the chart?

Or... is it the case that you want to "hide" all or some of them with one click of a button and then reactivate them if you need to?

[Kedar_Pande]

Refer the video: https://youtu.be/q8MkLFL6VW4?si=sZ7VeK4CTt3asKrp

This has the same usecase.

If this helped, a Kudos 👍or a Solution mark would be awesome! 🎉
Cheers,
Kedar Pande
Connect on LinkedIn

[PawelNie]

Thank you for your replies.

I have a little bit different case. Each line represents separate measures which based on different tables. How can I solve it?

[MNedix · Accepted solution]

I'm a bit confused, what is stopping you not adding those measures to the chart?

Or... is it the case that you want to "hide" all or some of them with one click of a button and then reactivate them if you need to?

[PawelNie]

Or... is it the case that you want to "hide" all or some of them with one click of a button and then reactivate them if you need to? - exactly, that's the point

[MNedix · Accepted solution]

OK, now it makes sense. It is fairly simple to do. As a summary you need to:
Step 1. make/configure your measures as a slicer and use that in your chart

Step 2: hide/show collection of measures

Step 1: use Parameter (see screenshot below)

1. Go to Modelling

2. Go to New Parameter

3. Use Fields as variables

4. Name your Parameter (in this case Chart Slicer)

5. Select the measures you want to add

6. Add the measures and reorder them

7. Create the Parameter

Then, in your chart, replace all the measures with the newly created parameter (see below)

Now you can select what measures you want to see directly from the slicer.

Step 2: hide/show collection of measures

You can do this step with the help of buttons and bookmarks. In a nutshell, you can create "x" number of buttons, each having a certain combination of measures (from the slicers) - see below screenshots.

Keep in mind that the buttons are activated by pressing Ctrl + click.

If you don't know how to create buttons/bookmarks then please check out this link from one of my favorite PowerBI Youtube'ers. (what you're interested in starts at 4:24).

Hope it helps 🙂

[PawelNie]

Works perfectly!

Thank you!  : )

[MNedix]

Heya,

Put the measure or column in the Filter of that visual and select only what you're interested in seeing.