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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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