Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
wynhodgkiss
Helper III
Helper III

% of column total in matrix not available for line chart

‎01-19-2023 04:48 AM

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? 

Labels:
Message 1 of 3
360 Views
0
1 ACCEPTED SOLUTION
PowerBIEnthu
Resolver I
Resolver I

‎01-19-2023 04:52 AM

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 

View solution in original post

Message 2 of 3
356 Views
2 REPLIES 2
wynhodgkiss
Helper III
Helper III

‎01-19-2023 06:06 AM

That works,thanks

Message 3 of 3
312 Views
0
PowerBIEnthu
Resolver I
Resolver I

‎01-19-2023 04:52 AM

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 

Message 2 of 3
357 Views

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

View All