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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Sylvine_Wyz
Helper IV
Helper IV

Display problem - table visual

Hello Everybody, 

I have a big problem for me.
It's very urgent
Until now, the display of this visual table was correct.
It no longer works.
It must to add the line.

Sylvine_Wyz_0-1639493942835.png

"Frn Order N°" is on "do not resume". But i don't resume this column, i can't choose last or first. If not, le lines would be false.

Sylvine_Wyz_1-1639494127227.png

 

Thanks in advance.

Have a nice day



1 ACCEPTED SOLUTION

Hi @Sylvine_Wyz 

 

OK. For "Frn Qte" and "Frn Prix" columns, you can select Sum to aggregate them. Then in Filter pane, set "Frn Qte" to show items when the value is not 0. Do this to "Frn Prix" if needed. 

21122202.jpg

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

5 REPLIES 5
v-jingzhang
Community Support
Community Support

Hi @Sylvine_Wyz 

 

Sorry I don't understand what the problem is. From the screenshot, "Frn Order N°" all display blank. Do you want to show their exact values in the column?

 

Best Regards,
Community Support Team _ Jing

Hello,
Thanks for your return.

No, for once, these lines do not have order numbers. But if the first line and the 6th had the same number, then the line total would be 0 and the line would not appear in the table.

Do you understand ? 

Hi @Sylvine_Wyz 

 

OK. For "Frn Qte" and "Frn Prix" columns, you can select Sum to aggregate them. Then in Filter pane, set "Frn Qte" to show items when the value is not 0. Do this to "Frn Prix" if needed. 

21122202.jpg

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Hello,

Thanks for your answer 🙂 
But the settings are already like this and it does not work..

Have a nice day

lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors