Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help on Line chart

HI All,

 

I have a requirment in line chart to display the X axis with week start dates for previous 3 months and by hover tool tip to show data for each date.For which have created a week start date column in date dim and used in the line chart.

Now the issue is when I hover over the line the default Tooltip is avaliable only for the points for the Week start dates on the X - axis.

example - Tool tip data is showing for (3rd July,10 July,17 July 2022) 

 

But here we need the tooltip to be shown for all the dates when hover on the line.

 

Please find the image of the same in excel.

 

In above image the weekstartdate is 3/12 but when hover on the line i could see tooltip for 3/19.

Would need help to achiev same in power bi.

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Anonymous ,

     

    To what I can understand from your post is that you want to present the values from the end of week date in tghe x-axis, however this is not possible in Power BI, you have two option on the X-axis:

    • Categorical that will present all data in your x-axis
    • Continuous that will return a continuous x-axis however the values presented on the the axis are based on the size of the chart, so if you increase the size of the chart you will see more reference points

    You cannot have a chart were you define what are the values presented.