Need help on Line chart

[Anonymous]

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.

[MFelix]

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.