Forum Discussion

Shloka_Lakhani's avatar
Shloka_Lakhani
Frequent Visitor
3 years ago

Create comparison chart using two Date Slicer in single Line Chart

Compare two custom date slicers into a single visual for line chart.    Also tried as below steps: 1) Created two Date slicer for Comparision Date and Custom Date. 2) Overlapped two line charts i...
General Comment
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Shloka_Lakhani ，

 

Power BI only support us to show tooltips from one visual. As far as I know, you don't need to overlap two line charts to achieve your goal. Here Iauggest you to calculate two lined by measures and create two unrelated date tables for slicer.

Line 1 =
VAR _SelectDate =
    VALUES ( 'Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'TableName'[Value] ),
        FILTER ( 'TableName', 'TableName'[Date] IN _SelectDate )
    )
Line 2 =
VAR _SelectDate =
    VALUES ( 'Comparison Date'[Date] )
RETURN
    CALCULATE (
        SUM ( 'TableName'[Value] ),
        FILTER ( 'TableName', 'TableName'[Date] IN _SelectDate )
    )

Add these measures into Y axis and then you can see tooltips at the same time.

 

Best Regards,
Rico Zhou

 

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