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

Report Design Suggestions

Hi All,

 

We need to implement a report as below.

expected report.png

Now the requirement is when user selects any One value(Ex:    Previous Quarter)
in slicer, user should not be able select year or quarter(Year selection
or Quarter Selection become invalid)

Is there a way to hide Year or Quarter Slicer, when user selects one values(Ex:
Previous Quarter) in time slicer.

Any other recommended design ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Report Design Suggestions

Hello @powerbieng 

You can't hide an entire slicer based on the selection in another slicer but, what you can do, is filter the list that appears in the slicer based on the selection in another slicer.

For example, if we have a master measure, something like Sales = SUM ( Orders[Amount] ) or whatever top tier calculation you want to use you apply a filter to all the slicers.

In the image below both the Year and Qtr-YR slicers have the filter [Sales Amount] is not blank applied.  When I select a value in one, the other is filtered to only the matching portion of the list.

FilterSlicers.jpg

1 REPLY 1
Super User
Super User

Re: Report Design Suggestions

Hello @powerbieng 

You can't hide an entire slicer based on the selection in another slicer but, what you can do, is filter the list that appears in the slicer based on the selection in another slicer.

For example, if we have a master measure, something like Sales = SUM ( Orders[Amount] ) or whatever top tier calculation you want to use you apply a filter to all the slicers.

In the image below both the Year and Qtr-YR slicers have the filter [Sales Amount] is not blank applied.  When I select a value in one, the other is filtered to only the matching portion of the list.

FilterSlicers.jpg

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 287 members 3,319 guests
Please welcome our newest community members: