Forum Discussion
Solved
How to create this table in Power BI?
Hi I have a below table I would like to have the output as below in matrix visual or any other similar visual I tried to use the matrix visual but was unable to get the ...
ryan_mayu Thanks a lot. It's working. I have one more question. What do I have to do if I need more categories to be displayed in '$', EXAMPLE Food, and Gym?
you can unpivot table and create a measure
Measure =
VAR _SUM=SUM('Table'[Value])
RETURN IF(SELECTEDVALUE('Table'[Category])="Money","$"&_SUM,_SUM)pls see the attachment below
ryan_mayu Thanks a lot. It's working. I have one more question. What do I have to do if I need more categories to be displayed in '$', EXAMPLE Food, and Gym?
pls try this
Measure = VAR _SUM=SUM('Table'[Value]) RETURN IF(SELECTEDVALUE('Table'[Category]) in {"Money","Food","Gym"},"$"&_SUM,_SUM)