Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line chart displaying last summarized value(no matter value is summarized or not)

Hi All,   I have a table of data that is populated using some calculated columns. I want to draw the line chart out of some specific values from this data but all I am seeing is the last summarized...
Need Help
  • P_D_G's avatar
    P_D_G
    5 years ago

    Anonymous :
    It's because your 'Project Stat of The Testline' column is incorect.

     

    Try to store this data in a separate Measure  (eg.: Project_Start_of_The_Testline_Measure = Date(2018,03,15) )

    And create another one which can be used as filter on the visual:

     

    Filter_Measure = 
    if( min( Trending Date) > Project_Start_of_The_Testline_Measure, 1, 0)

    Once you have the filter you can apply it on the visual:

     

    See attached PBIX file if needed.

     

    Please try to read and understand the data structure logic working behind PBI, it's different from Excel.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Drilling it down using arrows gives me error:

 

P_D_G's avatar
P_D_G
Icon for Resolver III rankResolver III
5 years ago

Anonymous :
It's because your 'Project Stat of The Testline' column is incorect.

 

Try to store this data in a separate Measure  (eg.: Project_Start_of_The_Testline_Measure = Date(2018,03,15) )

And create another one which can be used as filter on the visual:

 

Filter_Measure = 
if( min( Trending Date) > Project_Start_of_The_Testline_Measure, 1, 0)

Once you have the filter you can apply it on the visual:

 

See attached PBIX file if needed.

 

Please try to read and understand the data structure logic working behind PBI, it's different from Excel.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks P_D_G . I think your solution will work for me :)... Creating another measure as a filter and use it on the visual. I will try this soon and once done will mark it as a solution. Thanks again for your nice help. You made my day 🙂

     

    Best Regards,

    Nitin