Forum Discussion

laskawiec's avatar
laskawiec
Frequent Visitor
6 years ago
Solved

Tips on improving line chart clarity

Hi guys

 

This is my line chart

clicking to highlight is not useful (still hard to read the chart)

I'd ideally like to be able to switch each line on and of, BUT

we have 3 lines, score1(from 1 table of reviews), score2(from another table of reviews) and blended score (a weighted average of score1 and score2). I cannot append score1 and score2, so i tried creating a table for filtering (1 column, 3 rows: score1, score2, blended). Unfortunately i cannot create relationships because score1 and score2 have date fields that are both related to a common calendar table.

 

Is there maybe a custom visual with the ability to toggle each line on or off?

 

Thank you in advance for your engagement in this subject

Filip

Need Help
  • laskawiec's avatar
    laskawiec
    6 years ago

    Hi guys

     

    I ended up just creating a new table where I appended the separate tables, selecing only those that were necessary for the line chart. A simple UNION of SELECTCOLUMNS with a hardcoded source column was the easiest way out of this fiasco

     

    Thanks for your participation

    Filip

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello-

     

       Couldn't you just remove the data in the visual level filter for the times you want to turn it off?

     

    Jared

    • laskawiec's avatar
      laskawiec
      Frequent Visitor
      6 years ago

      Hi Jared

       

      I'd like for the report to be as simple as possible, therefore it would be nice to have the filter be on the report page if possible

       

      Thanks

      Filip

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    laskawiec ,

     

    Create a slicer based on the legend column in your line chart. Then you can select "score1", "score2" and "blendscore" when you need to turn on/off lines.

     

    Community Support Team _ Jimmy Tao

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

    • laskawiec's avatar
      laskawiec
      Frequent Visitor
      6 years ago

      v-yuta-msft 

      Hi

       

      unfortunately i don't have a legend since, as I said before, the lines are based on data coming from two different tables. I only have a common x axis (date)

       

      Thanks for engaging in the discussion

      Filip

       

  • laskawiec's avatar
    laskawiec
    Frequent Visitor
    6 years ago

    Hi guys

     

    I ended up just creating a new table where I appended the separate tables, selecing only those that were necessary for the line chart. A simple UNION of SELECTCOLUMNS with a hardcoded source column was the easiest way out of this fiasco

     

    Thanks for your participation

    Filip