Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm making a waterfall that will be filtered on a particular month.
I want to have one of the new report page tooltips pop up and show a graph for the whole 12 months. I've managed to get this working but just wondering if there is a simpler solution.
Code below:
Measure = CALCULATE ( [Period Value], FILTER ( ALL ( Periods ), Periods[Period] = MAX ( 'AllPeriods'[Period] ) ) )
[Period Value] is a measure which is just a SUM of a column. I have a table of periods which is what I usually use in slicers, etc. To get this to work I then need to make another table of periods and then give that a relationship to the Periods table. You have to force this to be a 1:* single direction relationship (even though it's 1:1) so that the relationship doesn't go "upstream". [EDIT: Actually you don't need a relationship at all.]
Then I use the AllPeriods table in my tooltip graph instead of my normal Periods table.
Usually I would just set the visual to not be affected by a slicer but that's not possible in this situation.
So it seems to work perfectly fine but having to create a duplicate table used just for this tooltip graph seems a bit overly complicated. Is there another solution for my DAX measure that means I don't need to create a separate table?
Hi @Veles,
From your description, if I understand your scenario correctly that you need to have two period tables to work your slicer.
By my test with the measure you provide and creating the tooltip, I could get the Slicer work with the Period in a single table like below.
It seems that I cannot reproduce your scenario, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |