Forum Discussion

yashwant101's avatar
yashwant101
Icon for Helper III rankHelper III
2 years ago
Solved

Need vertical line in bar graph

Hi all,   I am showing a bar graph to the clients. The graph is a monthly chart with months on x-axis. I need a vertical dashed or dotted line after one specific month. I cnnot put any shape or ima...
Need Help
Show and Tell
Tips and Tricks
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi yashwant101 - i have used with some sample data and in line chart you can use reference line and based on date create a measure and add conditional formatting.

     

     

    can you try the above logic

     

    SignificantChange1 =
    VAR CurrentMonthValue = SUM(financials[Profit])
    VAR PreviousMonthValue = CALCULATE(SUM(financials[Profit]), DATEADD(financials[Date], -1, MONTH))
    VAR PercentageChange =
        IF(
            NOT ISBLANK(PreviousMonthValue),
            DIVIDE(CurrentMonthValue - PreviousMonthValue, PreviousMonthValue, 0),
            0
        )
    RETURN
        IF(PercentageChange >= 0.2, 1, 0)  -- Assuming a 20% change is significant
     
     
    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!
rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi yashwant101 Expecting the sample file from your end, because you know the data and expectations, share it with us,will check from our end.

 

 

yashwant101's avatar
yashwant101
Icon for Helper III rankHelper III
2 years ago

Hi rajendraongole1 ,
I have not been allowed to share file yet but I can attach a screenshot:

Below is the expected graph:

In the above line and bar chart, we have a vertical dashed line for Oct-2023. That indictes that there was a significant change related to the orgnization in that month. I want to do this in Power BI for specific month.

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    2 years ago

    Hi yashwant101 - i have used with some sample data and in line chart you can use reference line and based on date create a measure and add conditional formatting.

     

     

    can you try the above logic

     

    SignificantChange1 =
    VAR CurrentMonthValue = SUM(financials[Profit])
    VAR PreviousMonthValue = CALCULATE(SUM(financials[Profit]), DATEADD(financials[Date], -1, MONTH))
    VAR PercentageChange =
        IF(
            NOT ISBLANK(PreviousMonthValue),
            DIVIDE(CurrentMonthValue - PreviousMonthValue, PreviousMonthValue, 0),
            0
        )
    RETURN
        IF(PercentageChange >= 0.2, 1, 0)  -- Assuming a 20% change is significant
     
     
    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!