Forum Discussion

MSojo's avatar
MSojo
Regular Visitor
2 years ago

Simple Percentages Calculated and Displayed in Line Graph

I'm new (very new) to PBI, and simply taking a value by product and dividing out to get a percentage. 
I'd like to graph percentages over time, but when I click on the respective line chart icon, it displays incorrect percentages.

It almost appears as though it's converting it to % of row, not column as I had displayed in the data. 
How can I correct? See the screen shot with the correct data to the left, however the incorrect line chart displayed on the right.

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    MSojo , BAsed on what I got , Assume you are using measure M1 in Matrix

     

    % Measure used in Matrix

     

    divide([M1], calculate([M1], removefilters(Table[common_drug_name] ) ) )

    • MSojo's avatar
      MSojo
      Regular Visitor
      2 years ago
      Hi Amit, Is there a way I could send you a file through this chat? I'm sure I am misinterpreting what you're stating, but I'd like to supply you with the information so you can comment. Thank you again, Matt