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,

 

The problem here is how we can get the data in your second post from the data in your first post. I can't find any connection. 

Can you modify the demo I attached before?

 

Best Regards,
Dale

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,

       

      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