The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 @Jay__ 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!!