How can I sort in Table visual without include the sort column ?

[yoshihirok]

I want to pin a Table visual to a dashboard without sort purpose column.

because Table visual in dashboard adjust row width to show all columns,
that become too narrow for dashboard.

I hope to in-visible the column of table visual for sort purpose at dashboard

Regards,

Yoshihiro Kawaata

[FarhanAhmed1984]

You can sort by another column to any column data using Sort By Column from Modeling tab.

I hope that this will resolve what you are trying to achieve.

[yoshihirok]

Hi @FarhanAhmed1984

Thank you for your advice.

Yes, Power BI Desktop's modeling - Sort by Column can sort each column with another column.

But, I want to sort the column of Real-Time streaming data in Power BI Service.

Power BI Service - edit does't have modeling feature, and Sort by Column feature.

Regards,

Yoshihiro Kawabata

[v-caliao-msft · Accepted solution]

Hi @yoshihirok,

For streaming datain your Power BI, we cannot download the pbix file, edit it and re-publish it. As you said, Power BI Service - edit does't have modeling feature currently. Thank you for your understanding.

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,
Charlie Liao

[yoshihirok]

Hi @v-caliao-msft

Thank you for your information.

I'm continue to build some dashboards, reports based on streaming dataset.

Now I have some idea.

But I left few votes for idea.

some day, I will post this as idea.

Regards,

Yoshihiro Kawabata