Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
maca128
Frequent Visitor

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:

delete.jpg

 

 

as:

delete2.JPG

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)

1 ACCEPTED SOLUTION

Click on the highlighted arrow from the matrix options

 

 

qjLZs

View solution in original post

4 REPLIES 4
NipponSahore
Resolver II
Resolver II

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

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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...

Click on the highlighted arrow from the matrix options

 

 

qjLZs

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.