Using slicer removes column from X-axis

[Milos_Milicevic]

Hi everyone,

I have a problem with PBI graph. When I use slicer to change view from Monthly to Weekly it removes Channel column from the X-axis and I need to manualy remove it from Visualizations pane and put it back in to show. I can't use Button + Bookmark because it's part of a large page that already uses some Button + Bookmark and graph needs to be independent. I added screenshots so you can see.

If you have any fix for this please let me know. 

Thank you!

Best regards,

Milos

[Kedar_Pande]

@Milos_Milicevic 

Rather than using separate measures for monthly and weekly data, create a unified measure that returns values based on the selected date granularity.

KPIValue = 
SWITCH(
SELECTEDVALUE(DateTable[Granularity]),
"Weekly", SUM(YourData[Value]), // Replace with your logic for weekly
"Monthly", SUM(YourData[Value]) // Replace with your logic for monthly
)

Use this measure in your visual and control it with a slicer that lets the user toggle between Weekly and Monthly without removing the Channel.

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

[Jonvoge · Accepted solution]

Hi Milos

When you use the slicer to change the date dimension, the drilling in your visualization resets.

All you need to do, is to click the arrows in the top right of the visual to drill down to the Channel level again.

To my knowledge, there is no way to permanently stay drilled at the Channel level when you alter the parameter, without resorting to bookmarks.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Milos_Milicevic]

Thank you for your answer. It does work when I click drill down button and it resets it. I have another question if it's not a problem. When I upload the file to the workspace it does not have option to drill down. Is there a way to make it visible?

[Jonvoge]

Hi Milos

If you select the Visual, and go into the Formatting options. Is the "Visual Header" option toggled on? This is necessary for the icons to show up once the report is published.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Milos_Milicevic]

Hi Jonvoge,

This worked. I didn't enable Header Icons on the graph. I enabled only "Expand to next level" and now it works on the published file.

Thank you!