Forum Discussion

rodieade's avatar
rodieade
Frequent Visitor
6 years ago
Solved

Chart with column and line value - only see specific value

Hello everyone,

I am creating a Line and clustered column chart with

  • a shared axis which shows period of time (P1-2020, P2-2020, ...)
  • column values for actual costs
  • line values for planned costs

Is there way to only see the actual costs for specific periods and the planned costs for other specific periods?

Thanks

Need Help
Tips and Tricks
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi rodieade ,

     

    Create a new table for slicer:

     

    Table1 = VALUES('Table'[Time])

     

     

    Create the following measure for actual costs and planned costs

     

    actual costs = IF(MAX('Table'[Time]) in DISTINCT(Table1[Time]),VALUES('Table'[actual costs]),BLANK())

planned costs = IF(HASONEVALUE(Table1[Time]),IF(MAX('Table'[Time]) in DISTINCT('Table1'[Time]),BLANK(),VALUES('Table'[planned costs])),VALUES('Table'[planned costs]))

     

     

     

    Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/personal/pbipro_qiuyunus_onmicrosoft_com/_layouts/15/onedrive.aspx

     

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

     

    Best Regards,

    Dedmon Dai

     

3 Replies

    • rodieade's avatar
      rodieade
      Frequent Visitor
      6 years ago

      Not sure I got you?

      because even the values with 0 appear on the chart.

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi rodieade ,

         

        Create a new table for slicer:

         

        Table1 = VALUES('Table'[Time])

         

         

        Create the following measure for actual costs and planned costs

         

        actual costs = IF(MAX('Table'[Time]) in DISTINCT(Table1[Time]),VALUES('Table'[actual costs]),BLANK())

planned costs = IF(HASONEVALUE(Table1[Time]),IF(MAX('Table'[Time]) in DISTINCT('Table1'[Time]),BLANK(),VALUES('Table'[planned costs])),VALUES('Table'[planned costs]))

         

         

         

        Please refer to the pbix file: https://qiuyunus-my.sharepoint.com/personal/pbipro_qiuyunus_onmicrosoft_com/_layouts/15/onedrive.aspx

         

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

         

        Best Regards,

        Dedmon Dai