Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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 Name | Actual | Target |
| Measure1 | 8 | 10 |
| Measure2 | 10 | 10 |
| Measure3 | 10 | 5 |
| Measure4 | 6 | 5 |
Thank you
Sree
@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,
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 46 | |
| 43 | |
| 39 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 68 | |
| 65 | |
| 31 | |
| 28 | |
| 24 |