Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Gantt Chart - Slicing Calculated Columns

Hello All, I am using the Gantt 1.14.3 visual to display timelines for my end users. Here's the challenge I'm facing and need help with...   The data I'm pulling has start/finish dates for each ta...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi

     

    Using the Query Editor, i have transformed your data as shown below.  You may download my PBI file from here.  Build your transformations from here.

     

    Hope this helps.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-chuncz-msft, 

    Thank you for the response. I'm not following how your link addresses my situation. The functions mentioned in that link seem to combine data from multiple columns into a single column (similar to concatenate?) and in a new table. Unless I'm misunderstanding your suggestion it doesn't seem like that accomplishes what I'm looking for. 

     

    In the below example I'm creating two calculated columns to find MIN and MAX and am using these for my start and finish dates in the Gantt chart. Those calculated columns use columns 1, 2, 3, & 4 in the formulas. My goal is to be able to use a slicer to determine which columns are actually included in those formulas. So my slicer for the below table would include (Col1, Col2, Col3, Col4, All). 

     

               Column 1, Column2, Column 3, Column4, Column 5 (Min Value), Column 6 (Max Value)

    Row1 -     5         ,       7      ,       9      ,      11      ,                   5               ,                11

    Row2 -     4         ,       21    ,       8      ,      13      ,                   4               ,                21

     

    Did I misunderstand your suggestion and/or does my above example make sense?

     

    Regards,

    Eric