Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am trying to show a comparison between Actuals vs Plan. I am using a Matrix table and for some reason only the Actuals shows up. In my source data (Excel) I have both a column for Actual and Plan and I would like to display them side by side. Is a Matrix table the right solution ? How can I get the Plan section to display next to the Actuals ?
Solved! Go to Solution.
Hi @Anonymous ,
What is the structure of your source data?
If Actual and Plan columns are in one table, create a table visual or matrix visual like @az38 said.
If they are in two tables, create correct relationship between the two tables. Then create a table visual or matrix visual like @az38 said.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
What is the structure of your source data?
If Actual and Plan columns are in one table, create a table visual or matrix visual like @az38 said.
If they are in two tables, create correct relationship between the two tables. Then create a table visual or matrix visual like @az38 said.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
You may have to create a table like this
union(
summarize (Table,"Name","Marginal ROA","Actual",[Marginal ROA Actual],"Target",[Marginal ROA Actual]),
summarize (Table,"Name","Effciency Ratio","Actual",[Effciency Ratio Actual],"Target",[Effciency Ratio Actual])
)
Or Convert measure to dimension values
Hi @Anonymous
add both of fields, Actual and Plan to Values in Visual Pane
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |