Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi guys, I need help with poer BI visual!
The above screenshot contains text box and cards separately, is there any way i can create it as a table?
the first column will be manually entered text, the next thre columns are separate measue (basically each card has a separate measure).
Kindly help!
Hello @Anonymous try using a combination of UNION and ADDCOLUMNS DAX functions.
Select New Table and write something similar to below DAX:
Consolidated Table =
UNION
(
ADDCOLUMNS(TABLE, "Metric Name",Expression),
ADDCOLUMNS(TABLE, "Metric Name",Expression),
ADDCOLUMNS(TABLE, "Metric Name",Expression)
)
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!
| User | Count |
|---|---|
| 52 | |
| 35 | |
| 22 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |