Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Below is an example of a report I created. In the settings of the cross tab, I selected "Format > Values > Show on Rows" to show this view.
However, my manager wants me to be able to show the data in this format where the Act, Bud and Var are on the same line for each metric but under the specialty.
This is how my data is structured in the data table.
Can anyone help me figure out how to display the data in the desired format?
Solved! Go to Solution.
You have to create a table and display that like one given below
new table =
union(
summarize(table,table[speciality],"name","Comp-phy-comp","Act",[Comp-phy-comp act],"Bud",[Comp-phy-comp bud],"Var",[Comp-phy-comp var]),
summarize(table,table[speciality],"name","Comp-app-comp","Act",[Comp-app-comp act],"Bud",[Comp-app-comp bud],"Var",[Comp-app-comp var])
)
You have to create a table and display that like one given below
new table =
union(
summarize(table,table[speciality],"name","Comp-phy-comp","Act",[Comp-phy-comp act],"Bud",[Comp-phy-comp bud],"Var",[Comp-phy-comp var]),
summarize(table,table[speciality],"name","Comp-app-comp","Act",[Comp-app-comp act],"Bud",[Comp-app-comp bud],"Var",[Comp-app-comp var])
)
THANK YOU @amitchandak !!! That works. I have not used the new table feature before so I didn't know that existed. I really appreciate your help.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |