Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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.
Solved! Go to Solution.
@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.
@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.
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.