Forum Discussion

luqmaanr's avatar
luqmaanr
Frequent Visitor
7 years ago

Visualization in Power BI

I am new to Power BI but able to manage around few times.  I am struggling to create cumulative of the data that I have. and some on time %.  My file contains the following screenshot below. My visua...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi luqmaanr,

 

I don't know which parts you already have and which parts you expect. Please download the demo in the attachment. Is it the solution?

Why does the **bleep** column start from 0?

Visualization-in-Power-BI2

 

Best Regards,
Dale

luqmaanr's avatar
luqmaanr
Frequent Visitor
7 years ago

Hi Dale

 

Thanks Again, this is the solution but it should read from the Export sheet table instead. When I am reading the cumulative from the export table it doesn't work.

 

The Planned vs Actual, what is the solution to not read the blank.  

 

I am unable to add an attachment. The bleep start with 0 as the start of the project.

 

Thanks

Luqmaan

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Luqmaan,

     

    How does the solution read from the Export sheet? I can't see any connections between these tables.

     

    Best Regards,
    Dale

    • luqmaanr's avatar
      luqmaanr
      Frequent Visitor
      7 years ago

      Hi Dale

      I think we had some misunderstanding here:

      1) The real data is the export work sheet

      2) the other screenshot (which is in my ‎11-23-2018 post) I sent you is an example of what I want to achieve with Export work sheet using Power BI. The screenshot was completed in excel.

       

      Thanks

      Luqmaan

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        7 years ago

        Hi Luqmaan,

         

        Yes, that's my assumption. You verified that. Now the question is how you will do to get the result without Power BI. Then I can do it in Power BI. 

        I have the sample file. But I don't know the logic from the real data to the result.

         

        Best Regards,
        Dale