Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Pivot graph in Power BI

Friends, I am new in Power BI and wanted to create a similar figure I created in Excel Pivot very easily. I could not find exact same conditions in web so I need your help. My table is similar below...
Need Help
Show and Tell
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    Hi Anonymous ,

    In this scenario, we can create two measures, one for "Above 4 days", one for "Below 1 Hr". Please refer to the following two measures:

    Measure = var a = CALCULATE(SUM(Table1[WO Turn Around Time]))
var b = CALCULATE(SUM(Table1[WO Turn Around Time]),Table1[Logic Text] = "Below 1 Hr")
return DIVIDE(b,a,0)

Measure2 = var a = CALCULATE(SUM(Table1[WO Turn Around Time]))
    var b = CALCULATE(SUM(Table1[WO Turn Around Time]),Table1[Logic Text] = "Above 4 days")
    return DIVIDE(b,a,0)

    The result will like below:

    Best Regards,

    Teige

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous ,

Could you please share the expected result like what's the X-asix like to us for analysis?

Generally, we cna use the slicer visual to set the filter, then use selectedvalue to get the selected data.

Best Regards,

Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

Thanks for the feedback, much appreciated. What I want to see in my graph changes on percentage of "below 1 hr" and "above 4 hrs" counts out of total count for each location.

 

Location can be put in filtering, not a problem. My problem was about the calculation of count percentages as a percentage of grand total for each individual "location" and "date". I dont want to see cumulitaive percentages but rather seperate for each month and put them into the graph to see the progress.

This is the graph ultimately I would like to see for each location (which can be filtered, no problem);

 

 

 

I attached the table I was working on but I gues I need to have some measures to do;

 

 

Thanks in advance...

  • TeigeGao's avatar
    TeigeGao
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Hi Anonymous ,

    In this scenario, we can create two measures, one for "Above 4 days", one for "Below 1 Hr". Please refer to the following two measures:

    Measure = var a = CALCULATE(SUM(Table1[WO Turn Around Time]))
var b = CALCULATE(SUM(Table1[WO Turn Around Time]),Table1[Logic Text] = "Below 1 Hr")
return DIVIDE(b,a,0)

Measure2 = var a = CALCULATE(SUM(Table1[WO Turn Around Time]))
    var b = CALCULATE(SUM(Table1[WO Turn Around Time]),Table1[Logic Text] = "Above 4 days")
    return DIVIDE(b,a,0)

    The result will like below:

    Best Regards,

    Teige