Forum Discussion

RPAI2812's avatar
RPAI2812
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's avatar
parry2k
Super User
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's avatar
    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.

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Community Support
      4 years ago

      Hi RPAI2812 ,

      Has your problem been solved? If not, your sample link is expired, would you please kindly share it again?

      Best Regards,
      Community Support Team _ kalyj