Forum Discussion

SreeY's avatar
SreeY
Frequent Visitor
4 years ago

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

  • rsbin's avatar
    rsbin
    Icon for Community Champion rankCommunity Champion

    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:

    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:

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

     

     

    • SreeY's avatar
      SreeY
      Frequent Visitor

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