Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Get column values depending on user details

I have 2 tables here, the user details table and the learnings table.

Scenario:
I will log in as [email protected] in the dashboard, I want to get the Learning Title that matches my details(Rank, MG and SL). Or should I say I want to get the Learning Titles that are applicable to me depending on my Rank, MG and SL.
For example, 
I am johnsmith, since my rank, mg and sl matches the learning title 1's rank, mg and sl, I want to get the learning title.

Is that possible with Power BI?


Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    According to your statement, I think you can try to configure dynamic RLS in Power BI Desktop.

    For reference:

    Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

    Dynamic Row Level Security with Power BI Made Simple

    I suggest you to merge [Rank]/[MG]/[SL] columns in both tables.

    Merage Column = COMBINEVALUES("-",Learnings[Rank],Learnings[MG],Learnings[SL])
    Merge Column = COMBINEVALUES("-",'User Details'[Rank],'User Details'[MG],'User Details'[SL])

    Data model:

    Configure rls in manage roles.

    When you view as  [email protected], you will only see data in "Learning Title 1":.

     

    Best Regards,
    Rico Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Exactly what I need, Thanks Anonymous .

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous 
      Actually, have another step to do, I have another table(Completed Learning Report). Once I identified what's applicable learning to me. I want to check if learnings in learnings table are present in the completed learning report. If not, then I want to display those learnings that are not present in both tables or not yet completed.


      Can you help me with this?

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Please read about Row Level Security.  And about the difference between a dashboard and a report.