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
SreeY
Frequent Visitor

Showing Individual Measures in separate rows.

Hi, I have a requirement to show measures in rows. Thease measure I have defined using DAX expressions, and they are independent. below is sample what my business is asking. The Actual and Target are calculated using 2 separate DAX expressions. per below example, I have total 8 separate measures (2 per each row). The Table and Matrix visuals are not helping me to show per requirement.

Appreciate your help. Thank you.

 

Measure NameActualTarget
Measure1810
Measure21010
Measure3105
Measure465

 

Thank you

Sree

2 REPLIES 2
rsbin
Super User
Super User

@SreeY ,

This is an example where you can really show some creativity. 

You can "make" your own table, using the Text Box, Shapes, and Cards.
An example of what I often do is something like this:

rsbin_0-1663266472951.png

The Measures are Text Box labels.  The blue lines I use Shapes, and then insert 8 different Card Visuals - 1 for each measure (I have only shown 2 here as demo).

Hence, to the User, it looks like a table.  You can go hog wild on the formatting.

Example of my Monthly Overtime Statistics:

rsbin_1-1663266668926.png

I believe I first learned this tidbit from Reid at Havens Consulting.  Have a look at his many youtube videos.
Regards,

 

 

SreeY
Frequent Visitor

Thank you @rsbin . I will try that and let you know. Appreciated.

 

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.