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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.