Forum Discussion

kincaids's avatar
kincaids
Helper II
9 years ago

percentages and multiple query columns

I'm new to Power BI and having a difficulty applying what I'm learning through the hours of tutorials to my particular situation, so your help is greatly appreciated.   Our company rents instrument...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi kincaids,

>>I'm getting "Renting - 0.47 (46.67%)" when I'm hoping to see "Renting - 7 (46.67%)"

The first -0.47 is round if 46.67%. "Renting - 7 (46.67%)", what's the mean of -7?

>> Where should the new measures for "% Rented Until Owned" & "% Early Payoff" go so that when I click on "Owners", I see a new chart showing 25% Rented Until Owned and 75% Early Payoff?  I don't even see the drill down icon above the pie chart when it's selected.

We can create drill down in Pie Chart by select multiple fileds in Legend level.  While 25% Rented Until Owned and 75% Early Payoff  are calculated by measure, the measures are not able to add Legend level.

Best Regards,
Angelia

kincaids's avatar
kincaids
Helper II
9 years ago


The first -0.47 is round if 46.67%. "Renting - 7 (46.67%)", what's the mean of -7?

 

 

It is from the example found further up in the thread.

 

 


We can create drill down in Pie Chart by select multiple fileds in Legend level.  While 25% Rented Until Owned and 75% Early Payoff  are calculated by measure, the measures are not able to add Legend level.

 

I'm not sure I'm following you here...could you expound on this?  Thanks!