Power BI - Don't show slicer with mandatory fields in dropdown menu.

[Anonymous]

Hi, everyone,

I have the following data selection:

1. SALES
2. DEMAND
3: FC1
4: FC2
5: FC3
...
n: FCn

The data "SALES" and "DEMAND" should be mandatory fields.
This means I only want to have the historical data "FC..." as a selection later in the slicer.

So i want to see this in my dropdown slicer:

1: FC1
2: FC2
3: FC3
...
n: FCn

However, I need the data "SALES" and "DEMAND" for the report.
But i can't just hide this data with the slicer.
I hope you understood me 🙂
Many Thanks
Flixy

[v-eqin-msft]

Hi  @Anonymous ,

@Samarth_18 's solution is effective. Could you share some screenshots to help us clarify your scenario since you mentioned it is not work on your side?

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Eyelyn Qin

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Its bit tricky part so have to handle it differently. Try to follow below steps:-

1. Create a seperate table for snapshots with below code:-

Snapshot_table = DISTINCT(FC_Data[Snapshot])

2. Now use newly created table in slicer.

3. Now create a measure with below code:-

Measure =
IF (
    MAX ( FC_Data[Snapshot] )
        IN VALUES ( 'Snapshot_table'[Snapshot] )
            || MAX ( FC_Data[Snapshot] ) IN { "DEMAND", "SALES" },
    1,
    0
)

4. User new measure as filter on your bar chart:-

output:-

Note: Make sure you are not creating any relationship with existing table with new table.

Thanks,

Samarth

[Anonymous]

Hi @Samarth_18 
thats not working in my Dashboard.
But thank you for the idea.

[Anonymous]

I want that the end user only can choose one "FC"-Snapshot.
The "Sales" and "Demand" should be automatically chosen.

So this is my database:

So i get this view:

But i only want to see one "FC".

If i filter now in the slicer without "Demand" and without "Sales" i get this:

Did you get my question? 😄

[amitchandak]

@Anonymous , is it a measure slicer?  Not very clear what you want.

With calculation group, you can get that multiselect and save with Demand and sales 

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

[Anonymous]

This is what i get after the steps: @v-eqin-msft @Samarth_18 

[Samarth_18]

@Anonymous I am hoping there is no relationship between these two tables?

[Anonymous]

@Samarth_18 i have created a relationship 😥
Now after delete the relationship its working 🙂