Forum Discussion

mkins's avatar
mkins
Icon for Helper I rankHelper I
3 years ago
Solved

Advanced control missing from bar and line chart?

Hi there,

 

I am trying to conditional format the markers on a line chart and have been reading that I will need to create a column chart and then convert to a line chart once the formating has been done. For context, I am looking to make the marker different depeniding on the value within another column i.e. not depending on x and y axis values used to create the chart. However, I can seem to figure out how to do this on the latest version of PBi (December 2022 update (2.112.283.0).

 

Does anyone know where it has gone? Or if it is not possible in this update, how I can down grade to a version where it is possible?

 

Thanks in advance,

 

Marc

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , mkins 

    In the line chart , we can only change the color for the whole line.

    If you want to change the color for the custom define.You need to create the measures to show the line chart the same before,like this:

    Before 2022/10 = var _cur_date = MIN('Table'[Date])
return
IF(_cur_date<= DATE(2022,10,1) ,SUM('Table'[Value]) ,BLANK())
    After 2022/10 = var _cur_date = MIN('Table'[Date])
return
IF(_cur_date>= DATE(2022,10,1) ,SUM('Table'[Value]) ,BLANK())

    Then we put the measures on the visual:

    Then we can change the colow in a line:

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

3 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , mkins 

    You mean that your desktop was updated to the version after the December 2022 update (2.112.283.0), and then you can't find and complete the feature "does not depend on the x and y axis values used to create the chart" feature, right? If that's the case, I think you might consider referring to this document to find the best desktop previous version for you, download and try it:

    Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

    • mkins's avatar
      mkins
      Icon for Helper I rankHelper I
      3 years ago

      Thanks v-yueyunzh-msft for your reply. Yes I updated my desktop version to the 2022 version. I see on forums and videos online that the used to be either an advanced options on data label colour, or 3 dots that allowed you to conditional format the line graph, but this isn't possible with the latest version. As you suggest I may look to download an older version.

       

      I have seen some example of people using DAX to conditional format the colour of a line, do you have any advice with this?

       

      Many thanks

      • v-yueyunzh-msft's avatar
        v-yueyunzh-msft
        Icon for Community Support rankCommunity Support
        3 years ago

        Hi , mkins 

        In the line chart , we can only change the color for the whole line.

        If you want to change the color for the custom define.You need to create the measures to show the line chart the same before,like this:

        Before 2022/10 = var _cur_date = MIN('Table'[Date])
return
IF(_cur_date<= DATE(2022,10,1) ,SUM('Table'[Value]) ,BLANK())
        After 2022/10 = var _cur_date = MIN('Table'[Date])
return
IF(_cur_date>= DATE(2022,10,1) ,SUM('Table'[Value]) ,BLANK())

        Then we put the measures on the visual:

        Then we can change the colow in a line:

        Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

         

        Best Regards,

        Aniya Zhang

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