% of column total in matrix not available for line chart

[wynhodgkiss]

Hi,

I have a matrix of products (rows) and dates (columns) with the values being units sold expressed as a % of column total. When I try to convert this into a line chart, I lose the % of CT and can only express units as units or % of Grand Total which is a very diferent result to the requirement.

Can anyone help with the DAX required to create the measure I need? 

[wynhodgkiss]

That works,thanks

[PowerBIEnthu · Accepted solution]

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=8f955ca8-...
Please go through the solution and attached PBIX file in given link. It seems similar to your issue