Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Create Line Charts with percentage of of column Total

In the matrix the data reads as % of Column Total.

 

Reshma_Doshi_2-1628527122198.png

 

But in a Line Chart the data converts to % of Grand Total 

 

Reshma_Doshi_4-1628527197334.png

 

How do I Use % of Column Total in a Line Chart. Do note my field used here is not numerical field - I need to use Count of field / Sum of the field for a specific month and represent that data month wise. 

App field contains App used & Month has data in which month the app was used. 

 

Created this measure but it doesnt help

 

Pct of App =
DIVIDE(
COUNTA(Video[app]),
CALCULATE( COUNTA(Video[app]), ALL (Video[app])
) )

 

Look forward to a response on this one as nothing seems to work. 

Status: New
Comments
v-chuncz-msft
Community Support

@Reshma_Doshi

 

You may refer to the posts below. 

By the way, If you have any other question about data shaping, modeling, and report building in the Power BI Desktop app, feel free to post a new message in Desktop forum.

Reshma_Doshi
Regular Visitor

Thanks for the Reply. 
But my values are not numeric - like Sales or Price. They are based on count. 
SO the Sum function will not work.