Combine dimensions in slicer with two different measures
We want to combine dimensions from two different measures in one slicer.
We have made an analysis where we use expected numbers from year 2018 to 2030 and actual numbers from year 2010 to 2021. We have these in two different measures and with one dimension. I want to make a slicer from year 2010 to 2030. If I create a slicer with the measure that contains expected numbers, I get from the year 2018 to 2030, and with the other measure, I get from year 2010 to 2021. I have also tried to create a slicer that includes both measures, but the outcome depends on which measure is on top. Can I get a slicer from the year 2010 to 2030, and if not, can you help make this happen?
2
Comments
Hi Camilla,
This is a valid feature request that I will forward internally.
Once it has been discussed and potentially planned, you will see a changed status of this post.
Until then, I think you can use this work around: Add a calculation (as a new measure). The calculation should just sum up the other two measures, e.g.,: sum(d1, 0, m1) + sum(d1, 0, m2)
BR / Ole
Please sign in to leave a comment.