Forum Discussion

maca128's avatar
maca128
Frequent Visitor
8 years ago
Solved

newbie doubt

Hi experts,

 

I have some experience but only with ‘report builder’ for SSRS, this is completely new to me.

 

I need a proper guide or a tutorial.

 

I want to display this:

 

 

as:

How can I do it?

 

 

Ps: in the future I will like to do similar stuff… So if tutorials aren’t good enough I thought of a book, I haven’t found much online… is the book for the exam good to learn stuff like the above (Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI)

4 Replies

  • You can try the following 

     

    Creating a matrix with 

    Rows --> MemberID

    Columns --> Metric Name, Completed Date

    Value -->Units Passed

     

    Also you can remove the  Year,Quarter and Date from the Hierarchy. 

    Let me know if that works

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion

      Only thing I will add is that you will need to use the forked arrow icon in the Matrix to drill down to the Month level of your hierarchy.

      • maca128's avatar
        maca128
        Frequent Visitor

        Hi, thanks for the help, but if I do:

         

        Columns --> Metric Name, Completed Date

         

        I get either by month or by metric name, and I need both at the same time as my screenshot above...