Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Creating a Calendar that changes depending from a MS Project group of projects. from a data Slicer

Hello, sorry for my broken English , i will try to explain my situation, 

I want to create a Graphic that showed the Earned Value Analysis form a group of projects, i once managed to get a table that worked the way i wanted, by selecting in a Data Segmentation or slicer a specific project it changed the length of the X Axis of the graphic sadly i got a loading error that never stopped, making me lose my recent advances,  

i have two main Tables, "Projects" and "Tasks", i remember it working on the "Project" table, but now i only get a Giant Scramble of Lines on the Graph

the black box is the data Slicer, 

my actual calendar code:
"

Calendario =
ADDCOLUMNS(
    CALENDAR(
        MIN(Proyectos[Actual Start]),
        MAX(Proyectos[FechaFinal])
    ),
    "Year", YEAR([Date]),
    "Month", FORMAT([Date], "MMM"),
    "MonthNumber", MONTH([Date]),
    "Quarter", "Q" & FORMAT([Date], "Q")
)

"

 

Need Help
Tutorial Requests
  • Praful_Potphode's avatar
    Praful_Potphode
    8 months ago

    Hi Anonymous ,

     

    Please try attached PBIX file and let me know if it works.

    PBIX

     

    Thanks and Regards,

    Praful

     

    Thanks and Regards,

    Praful

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 months ago

      Hi Praful_Potphode , thanks for your answer, i am trying to assimilate it to my specific conditions, but  my issue is that my slicer uses the Name of the project,  because i want to in one slicer be able to select the project of wich the KPI and Graph are shown, i am no experienced enough to transform the answer you gave me.

      My idea is to be able to select a proyect and that the visualizers tell me the total percent complete, the EV, the AC, and PV, and changing the length of the X Axis.

      Like you can see on the pictures, the graphs look empty, thats because its not  changing and it keept the original total length of all the projects,
      On each of my tables i have the same information on columns, like: "Name", "Source.Name", "Baseline Start", "Baseline Finish",  "Actual Finish",  "Actual Start", "Earned Value", "Actual Cost", "Planned Value" and "Percent Complete" and "

      the mayor diference is between tables is that Projects has only the general and sum of the data, 
      and tasks is more in depth. 

      • Praful_Potphode's avatar
        Praful_Potphode
        Super User
        8 months ago

        Hi Anonymous ,

         

        Please try attached PBIX file and let me know if it works.

        PBIX

         

        Thanks and Regards,

        Praful

         

        Thanks and Regards,

        Praful