Forum Discussion

jovani's avatar
jovani
New Member
3 years ago
Solved

Create Line Chart from a Table with multiple Date Columns

Hello all,   I am creating a line and clustered column chart in which has multiple columns of dates that share the same object ID (Sub-Systems) in each row.   In this case we have 2 columns of da...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi,  jovani 

    Based on your requirement description, it seems you want to explore if there is an option in which allows me to filter out a y axis line and only focus on one. If you are searching for this method to achieve this in the Power BI report, I suggest you to use the "Field parameter" as the method to achieve this, you can create a "Field parameter" for the Y-Axis for the line chart and place a slicer for the Y-Axis for the line chart to dynamically select the Y-Axis you want to display for the line chart and manage  to filter out a y axis line and only focus on one

    Let report readers use field parameters to change visuals (preview) - 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

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Create an inactive relationship from the Forecast column to the Date column of the Calendar Table.  Use a DAX measure pattern like this

Measure = calculate(sum(Data[Sales]),userelationship(Data[Forecast],Calendar[Date]))