Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
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.
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
Hello-
Couldn't you just remove the data in the visual level filter for the times you want to turn it off?
Jared
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