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
luqmaanr's avatar
luqmaanr
Frequent Visitor
7 years ago

Hi Dale,

 

The data in my second post is from Excel, using the same format of the data from my first post. I was able to do it in Excel, but found Power BI can easily connect to application and we want to utilitze it.

 

In excel, I can write my formula to count (COUNTA) the Planned date <= today() for each month and same for forecast. But for actual no need, you can just COUNTA.  

 

I want to achieve the following.

1) Planned, Forecast and Actual will be the column data, cumulative planned, cumulative forecast and cumulative actual will be line as secondary axis

2) Planned, forecast and actual will be cumulated

3) % ontime = Planned vs Actual - Planned is to count all the planned date <=today ().

 

I cannot attach excel file in this forum, please let me know if you need additional info.

 

Thanks Again.

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

  • luqmaanr's avatar
    luqmaanr
    Frequent Visitor
    7 years ago

    Hi Dale,

     

    On the below graph How automatically would I stop projecting once they have reached their last data point for the cumulative data.

     

    The cumulative line should stop on Dec 2018. Please help

     

    Here's the formula:

     

    Forecast accumulated = CALCULATE(sum(Table1[Bidders List Approved - FORECAST]), FILTER(all('Calendar'[Date]), 'Calendar'[Date]<=max('Calendar'[Date])))

     

    thanks

     

    • luqmaanr's avatar
      luqmaanr
      Frequent Visitor
      7 years ago