Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
6 years ago

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 pl...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

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's avatar
Zakaria_1980
Post Patron
6 years ago

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

Thanks

 

 

 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    6 years ago

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