Forum Discussion
Plot arrow automatically
Hi,
Please under my DB, i have one column called current week and another column with date. I ve graph where i have actual sales per date (i display only month&year). I need that an arrow will be plotted automatically depending on the current week column in the same graph.
Thanks in advance.
9 Replies
please I need the arrow to be shown automatically. in the below case, i'm plotting the arrow manually to refelect where we are in W18. i need the same but the plotting of the arrow will be shown automatically.
Thanks in advance.
Hi Zakaria_1980 ,
Power BI doesn't support to plot arrow in a line chart currently. How about plotting a dynamic reference line on x-axis?
In your scenario, you can
1. create a "line and stacked column chart";
2. Put column [Date] into shared axis and put [actual sales] into line values.
3. Put column [CurrentWeek] into column values and choose "Count".
Or, create a measure like this, put this measure into column values.
CurrentWeek Measure = IF(SELECTEDVALUE('Table'[CurrentWeek])<>BLANK(),1)To hide the y-axis (column), do this:
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
it seems it's good, i adapt it to my DB, but we have another issue, you example is showing the case that we are in the same year 2020. however my case is following the progress on projects throughout their life cycle which may take 3 or more years.
how can we deal with the same example if we have the current week but related to many years (2018, 2019 & 2020)?
can you take the same exapmle and share with me the output as you did in power bi report
Thanks
Hi Zakaria_1980 ,
Is this what you want?
For hide the y-axis, try to change the color to white.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
please how we can hide even the numbers highlited in yellow (left hand side) ?
Thanks
switch off the Y axis in your settings (the little painbrush)
