Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

line graph to show multiple plots when using slicer

Hi Experts
 
I have cannot see the wood for the trees, here not sure if this can be done, see pbix file. 
1. I have created a total measure which gives me the overall total value for the status points (correct) 
2. i have a measure called selcetedvlaues which should allow me to plot the selected status against the total value which works fine for a single data point. 
3. i have two measure status A and B which give me the correct plots for the single selected data point against grand total line, but i do not want to create 50 measures for all my products. 
can this not be done dynamically based on selelcted from slicer.

https://www.dropbox.com/s/86i4f108hb4v5w3/line_and_bar.pbix?dl=0
 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    I understand now. There is no easy way to accomplish this with a line chart. It will require a lot of work with DAX expressions. However, you can easily display the data in a line and cluster column chart. I have attached a screenshot of how I created a line and cluster column chart with your example report.

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Anonymous ,

     

    If I understand your requirements properly, you shouldn't have to create a new measure for each product. Instead use the field 'amount' as the value field for the line chart and keep the status slicer. 

     

    I hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Expert

       

      Placing the field Amount into the Value... Does not give me a line for total and for each individual product... i need to show three / four or evern lines on the graph at any given time..the total also has to have its own line...

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        I understand now. There is no easy way to accomplish this with a line chart. It will require a lot of work with DAX expressions. However, you can easily display the data in a line and cluster column chart. I have attached a screenshot of how I created a line and cluster column chart with your example report.