Forum Discussion
Help recreating a unique table in excel
I would like to recreate the table in the screenshot below. I am wondering if the best way to do this would be a calculated table but I am im not sure and I am open to suggestions. In the tabl...
Hello Anonymous
Thank you for reaching out to the Microsoft Community Forum.
Thank you danextian for your prompt response.
To recreate the table in Power BI, use a Disconnected Table and a SWITCH DAX measure.
- Create a Disconnected Table for Measure Names and create a Measure to Switch Between Values.
- Next, add a Matrix Visual from the Visualizations pane.
I have attached a PBIX file for a more detailed understanding. Please review it:
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank You!
danextian thank you this is a good start, is there a way to add the difference measure and attainment calculation to the row of this table as shown below