Application of Slicers on the Visuals

[brjeeth]

I need help with applying the slicers to the respective set of visuals. I have described the problem in the screenshot below and also attached the PBIX file for reference

Slicer Application.pbix (550.1 KB)

[brjeeth]

My apologies for not tagging the request to appropriate section. I cannot however tag it now so if you can please tag it to “PowerBI” that will be helpful.

Regards,
Ranjith

[EnterpriseDNA]

Hi @brjeeth, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

• Use the forum search to discover if your query has been asked before by another member.

• When posting a topic with formula make sure that it is correctly formatted to preformated text </>.

• Use the proper category that best describes your topic

• Provide as much context to a question as possible.

• Include demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.

[samaguire]

Seems this is solved in this post?

Applying two slicers from the same field on Table visual

@brjeeth, Super interestingly, this brings us full circle back to our conversation a few days ago about the use of slicers built on disconnected tables, connected virtually to the relevant fact table(s) via TREATAS. We can use that exact same technique here - Ad Type I is a normal slicer based on Ad Type, while Ad Type 2 is based on our disconnected table. The left (blue) side of the comparison uses “normal” measures since the Ad Type 1 slicer comes from a field connected within our data m…

[brjeeth]

@samaguire : I have been using the suggestions from the previous post to build on…

As you see, the problem here is:

1. Apply the respective slicer but also rank on one measure while displaying another measure.

2. Use both the slicers and display the Customer across the selected Ad Types…

I have tried to explain the problems in more detail in the PBIX file. Hope they make sense.

Ranjith

[BrianJ]

@brjeeth,

Q1: Create a RANKX-based measure to rank Products based on [Total Orders Adv-1], and then set a visual-level to show only Rank <= 7.

Rank Products = 

IF( HASONEVALUE( Products[Product Name] ),
    CALCULATE(
        RANKX(
            ALL(Products),
            [Total Orders (Adv1)],,
            DESC,
            Dense
        ),
        ALLSELECTED( Sales[Ad Type])
    ),
    BLANK()
)

Advanced RANKX - How To Understand This Function More Deeply

Q2: You’ve hit on one of my pet peeves about Power BI - while it’s very easy to dynamically hide rows in a matrix or table, it’s really difficult to do the same for columns. @jcgrigsby and I worked out an approach last year that may work for you here. If this doesn’t work for your particular case, let me know – I have some other ideas about how to do this, although aesthetically they’re not ideal.

Hope this is helpful.
• Brian

Dynamic Visuals - Displaying Multiple Measure Columns

Hello, I have implemented an Income Statement report based on the Financial Reporting tutorial and would like to be able to dynamically display multiple columns at the same time, selected by filter with “multiple selection” turned on, ie diplay both actuals and % of revenue side by side. I have a total of 5 options I would like to dynamically control: CY Actuals, PY Actuals, % Revenue, $ Change and % Change. This currently works if one item is selected, but if multiple are selected it is blan…

[brjeeth]

@BrianJ: Thanks again for your quick response and solution!!

Will give both a try.

[BrianJ]

@brjeeth,

One other thing I meant to mention - your data has a lot of ties in it, and so you’re going to need to decide how to handle that in RANKX. There are three ways to do this - Dense, Skip and custom tiebreaker. Dense and skip are described below.

Custom tiebreakers are used when you have a secondary criteria to do another RANKX on to differentiate tied items (products, in this case). In some use cases, people just use RAND() or RANDBETWEEN() to break ties.

Dense is probably the most common option, which is what I used in the example measure.

• Brian

[EnterpriseDNA]

Hi @brjeeth, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!