cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Super User
Super User

How to make P&L INDEX 3 , 10 , 12 don't appear ?

Hi All

 

I have a P&L file from @VijayP working fine , it can display index  2 , 3 , 10 , 12 , 14 which is correct.

admin11_0-1613359727153.png

Below link is working PBI file :-

https://www.dropbox.com/s/2p3mymck583aumc/GL_WORKING.pbix?dl=0

 

I try to do duplicate above , INDEX 3 , 10 , 12 don't appear ?

 

Have check :-

- All table and field are both same.

- Compare the link between all table are similar.

- Have check index 3 10 12 appear at Table B.

admin11_0-1613359909060.png

 

Below is my PBI file :-

https://www.dropbox.com/s/h10ks9th3lh1i06/GL_NOT_DISPLAY_COGS.pbix?dl=0

 

i suppect it is due to expression on Total Sales_1 :-

 

Total Sales_1 = CALCULATE(SUM(GL_TI[C/D]),Fin_Category[Summary]="SALES")*-1
 

admin11_0-1613365125662.png

I have try to check the Table , it does have value label " SALES ". But index 3 on ward still refuse to come out.

admin11_0-1613365272714.png

 

what else i should check ?

 

Paul 

 

 

 

2 REPLIES 2
jdbuchanan71
Super User
Super User

@admin11 

It looke like those 3 indexes are not appearing becasue the GL accounts they are assigned to in the Formt_PnL table have no values in the GL_TI table.

jdbuchanan71_0-1613374646560.png

 

@jdbuchanan71 

Below link is working PBI file :-

https://www.dropbox.com/s/2p3mymck583aumc/GL_WORKING.pbix?dl=0

i have 2 PBI File , both are load with same raw data. Above PBI able to display all Index . 

my PBI file I try to duplicate by create by myself . The issue is Cause by the Total Sales expression suppose pick up those sub category amount for index 3 onward, This PnL only have 3 table , but the linkage look simple , yet I cannot figure where go wrong ?

 

37CDD952-8008-4C9B-893E-73C6C1F64494.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors