cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
laskawiec
Frequent Visitor

Tips on improving line chart clarity

Hi guys

 

This is my line chartlinechart.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
laskawiec
Frequent Visitor

Re: Tips on improving line chart clarity

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

View solution in original post

5 REPLIES 5
jared_farber Resolver III
Resolver III

Re: Tips on improving line chart clarity

Hello-

 

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

 

Jared

laskawiec
Frequent Visitor

Re: Tips on improving line chart clarity

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

Community Support
Community Support

Re: Tips on improving line chart clarity

@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
Frequent Visitor

Re: Tips on improving line chart clarity

@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
Frequent Visitor

Re: Tips on improving line chart clarity

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

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors