Forum Discussion

Gusdate2's avatar
Gusdate2
Helper I
4 years ago

Pass single parameter in visual to visual filter (or hide columns in visual no filter)

Thank You for looking...   So the overarching goal is I want different individuals to visit a page monthly and view that months forecast vs actual numbers by group in a matrix...and then trending i...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

Gusdate2 check the attached file, you need a disconnected table for the matrix visual. In the attached pbix file I just did it for one visual and one measure, you can take it from there.

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort 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.

  • Gusdate2's avatar
    Gusdate2
    Helper I
    4 years ago

    parry2k Thank you for replying. In re-reading your response. I have re-read your reply a few times and looked at your attached .pbix and I think I didn't make what I was looking to do clear. If I disconnect the table the formulas break. The formulas are the sum of all months, not the latest month. Total Actuals is correct, and I can switch thet to total forecast being correct (but then total actuals breaks).

    I figured I would graphically try and show what I am hoping to accomplish. If I am just missing something from the solution could you enlighten me. Again, thank you very much for the reply, and you gave me a few things to think about, but right now I am still looking for a solution.

     

    Goal (Taken from my example .pbix No Filter Page)

     

     

    Taken from parry2k solution with filter page