Forum Discussion

Helper I

4 years ago

Solved

Filter with pivoted data doubt

Hi! I need help with the best way of filtering my data with slicers 🙂 I have attached the data of two tables in a link at the end of this post. The first table has some operational and costs...

Need Help

parry2k
4 years ago
RPAI2812 is this what you are looking for?

✨ Follow us on LinkedIn and to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.

RPAI2812

Helper I

4 years ago

Not a 100% exactly like this, but this is on the way.
In your solution the measure shows the full amount of passengers of each travel. I needed it to show the amount related to that specific cost center.

For instance, Travel 9 I had 10 passengers, being 10% for CC1, 80% for CC2 and 10% for CC3. Instead of always showing Travel 9 with 10 passengers in each of the sliders, what I want would be CC1 showing 1, CC2 showing 8 and CC3 showing 1.