Forum Discussion

mircealitoiu's avatar
mircealitoiu
Frequent Visitor
5 years ago

Help please - Line chart with percentages from total

Hello everyone,

 

I am struggling with showing the measure I have created ( percentage from total for each application) in a line chart.
In a bar chart the data is correct, but I need it as line chart - so I can see the evolution over time, and for somewhat reason the line chart divides the values for each day, instead of showing the actual values.
In the images below, you can see for example thtat the first one has 28% for one day and 27.69% for another day. Looking at the line chart, we are seeing values of around 2%. 
PS: It is not a matter of multiplying because some other applications, which should be like 0.5% of total are showing like 4% into the line chart.

 

 

EDIT: I have found the solution in another topic.

 

Measure = 
DIVIDE (
    SUM ( 'Fruit Sample Data Set'[ Units Sold ] ),
    CALCULATE (
        SUM ( 'Fruit Sample Data Set'[ Units Sold ] ),
        ALL ( 'Fruit Sample Data Set'[Fruit] )
    )
)

 

 

Appreciate any help that can be given!

Mircea

 

 

3 Replies

  • mircealitoiu , Have marked this column as % column in column tools

     

     

     

    Other than each visual can have option for format, so check if that as been used in BAR if first one(Column property)  is not %

    • mircealitoiu's avatar
      mircealitoiu
      Frequent Visitor

      Hi amitchandak!
      Thank you for your answer. I have checked and the measure is formated as %, as you can see below.

       

      I am not sure where to check this "Other than each visual can have option for format, so check if that as been used in BAR if first one(Column property)  is not %". 

      Could you please give an example?

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  mircealitoiu  ,

     

    You need to ensure that the fields on the x-axis of your two visual objects are the same to display the same data.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.