Plot arrow automatically

[Zakaria_1980]

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.

[Icey]

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.

[Zakaria_1980]

please how we can hide even the numbers highlited in yellow (left hand side) ?

Thanks

[vanessafvg]

switch off the Y axis in your settings  (the little painbrush)

[Zakaria_1980]

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

[Icey]

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.

[Zakaria_1980]

i would like to show the bar chart for selected Week as you did before but only for the current year. not plotting it for all years that i've in my DB.

because i'd like to show the progress on the project until current week in current year.

Thanks in advance.

Br,

[Icey]

Hi @Zakaria_1980 ,

Just change the [CurrentWeek] column like so:

CurrentWeek =
VAR Week_ =
    WEEKNUM ( [Date], 1 )
VAR CurrentWeek =
    WEEKNUM ( TODAY (), 1 )
VAR Year_ =
    YEAR ( [Date] )
VAR CurrentYear =
    YEAR ( TODAY () )
RETURN
    IF ( Year_ = CurrentYear && Week_ = CurrentWeek, "W" & CurrentWeek )

Best Regards,

Icey

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

[amitchandak]

@Zakaria_1980 , refer if this can help

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

https://powerbi.tips/2019/07/icons-upon-icons/

https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[Zakaria_1980]

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.