Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Leasie_7
Frequent Visitor

Take value from connected slicer and translate over so disconnected slicer gets selected

Here's the scenario & what I would prefer to achieve.

 

I have a report with a connected slicer for the month and cards that show the corresponding numbers from tableA.

I then have a line graph showing the same numbers from tableA but for all last year & upto the date selected on the previously mentioned connected slicer. In order to do this I needed to create a disconnected calendar table, add a separate slicer to use with the measure to generate the numbers from tableA and a new measure to use the time frame constraints. 

 

What I am wondering is, instead of changing the report & the numerous measures to work with this newly disconnected slicer. Can I somehow translate the month chosen from the connected slicer and pass it to the disconnected so the line graph works in essence automatically so I do not need to rework other measures? The disconnected slicer could just be layered over and not seen if I could somehow have say "show" selected which would correspond to the month chosen in the connected slicer. 

Below is just a rough idea so you can "see" what I'm talking about.

 

Leasie_7_0-1692997612448.png

 

 

I have this measure so I can constrain down the disconnected month slicer to only show what applies, but because the months change I cannot simply select 1 value and have it dynamically update.

 

This/Last Month - Show / Hide =
var MaxSelectedMonth = MAXX(ALLSELECTED(DimCalendar[This/Last Month]),DimCalendar[This/Last Month])
var DisMonth = SELECTEDVALUE(DimCalendar_Disconnected[This/Last Month])
var Show_Hide = IF(MaxSelectedMonth = DisMonth,"Show","Hide")

Return Show_Hide
 
Thank you for any suggestions you provide.

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Leasie_7 I don't think that is possible. You can easily achieve this by creating a calculation group, adding the logic to the calculation group, and applying the calculation group to all your visuals. It means, all the measures you have will use the logic you apply in the CG and you don't have to manually do the measures:

 

It will be something like this:

 

- Start TE2 (it's free)

- Add a new Calculation Group, let's call it "Apply"

- Add one Calculation Item, let's call it "Yes"

- Add the logic in the calculation item like this:

 

CALCULATE (
   SELECTEDMEASURE (),
   <<your new logic that you used in the measure>>
) 

 

Save changes, and refresh your model.

 

Now at the page level or visual level filter (depending on what you want), select "Yes" from this new CG and this will work with any measures you have in the visuals.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

2 REPLIES 2
parry2k
Super User
Super User

@Leasie_7 I don't think that is possible. You can easily achieve this by creating a calculation group, adding the logic to the calculation group, and applying the calculation group to all your visuals. It means, all the measures you have will use the logic you apply in the CG and you don't have to manually do the measures:

 

It will be something like this:

 

- Start TE2 (it's free)

- Add a new Calculation Group, let's call it "Apply"

- Add one Calculation Item, let's call it "Yes"

- Add the logic in the calculation item like this:

 

CALCULATE (
   SELECTEDMEASURE (),
   <<your new logic that you used in the measure>>
) 

 

Save changes, and refresh your model.

 

Now at the page level or visual level filter (depending on what you want), select "Yes" from this new CG and this will work with any measures you have in the visuals.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

foodd
Super User
Super User

Please create a pbix file that contains some sample data but still reflects your data model (tables, relationships, calculated columns, and measures), upload the pbix to Onedrive or Dropbox, and share the link. Please use Excel to create the sample data instead of the manual input method share the xlsx as well.

 

Describe the expected results based on the sample you provide.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.