if selectedvalue equals then filter in a slicer

[CR]

Hi guys,

I would like that one specific value will be selected dynamically in a slicer based on one condition.

I got the table TimeFrame.

ProjectId	TimeFrame	Data	FilterOption
4019	TimeFrame1	Data1	0
4019	TimeFrame1	Data2	0
4019	TimeFrame1	Data3	0
4019	TimeFrame2	Data4	0
4019	TimeFrame2	Data5	0
4019	TimeFrame2	Data6	0
9028	TimeFrame1	Data1	1
9028	TimeFrame1	Data2	1
9028	TimeFrame1	Data3	1
9028	TimeFrame3	Data4	0
9028	TimeFrame3	Data5	0
9028	TimeFrame3	Data6	0

I get 2 visuals: one table and one slicer.

1 get one filter: ProjectId

I would like that:

- when I filter on the project 4019, TimeFrame 1 & 2 are both displayed (classic display)

- when I filter on the project 9028, TimeFrame are filtered directly on TimeFrame1 only

By filtering, I mean => TimeFrame1 is selected automatically in the slicer (the other time frame remains selectable)

I tried to create a measure combining IF SELECTEDVALUE = 9028 then FILTER ON but I don't see how to get it right and, above all, how to assign this measure to a slicer.

Someone already solved this kind of case ?

Thanks,

CR

[parry2k]

@CR as mentioned you cannot set the default value in the slicer but you can always set the default value in the SELECTEDVALUE function which is the 2nd parameter:

For example:

My Value = 
SELECTEDVALUE ( 
Table[Column], 
//this is where you can put the logic for default value based on project
SWITCH ( MAX ( Table[Project] ),
   "Project1", "TimeFrame1",
   "Project2", "TimeFrame2",
   "TimeFrame0" 
)
)

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[CR]

Ok, noted. It's just I don't understand what you are doing in this measure and how / where you apply it... To be investigated.

[parry2k]

@CR what are these 3 and 72? How this decision is made?

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[CR]

Sorry, i mean:

- the TimeFrame 3 for project 2

- the TimeFrame 72 for project 4, etc.

The timeframe is a step of a project but not linked to a planning, a date.

This is just decided and defined by the project manager that said for example on January 1st that the project 2 is on TimeFrame 3 and, let's say on March 23th, the project 2 moves to the TimeFrame 4. That's it.

However, it is also possibe that the TimeFrame to "pre-select" is the number 3 even if you are still on February (so link with the date of the day as well).

All visuals available in the sheets are linked to the TimeFrame so, it is really better to be able to select a specific TimeFrame by project, whenever we need, to display visuals according to the TimeFrame we want (but we have to keep the other ones in the slicer !).

Last information => the report gathers all the projects so we need to find a way to assign the TimeFrame we want for each project within the same report.

Hope it's more clear.

CR

[parry2k]

@CR what is your end goal? You can't select values in the slicer automatically but if we know what is your end goal there might be a solution. 

[CR]

Hi,

The goal is, when the list of TimeFrame (1 to 100) is very high on some projects, I need to select one specific value by default for each project (the 3 for project 2, the 72 for project 4, etc.).

CR