Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
admin11
Memorable Member
Memorable Member

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.