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
12Bowers12
Helper V
Helper V

Create Visualization Table using table function

HI, everyone,

The following code creates a table. Is there a way to create this table direclty  to Report as a visulization Table using any table function?

Thank you.

Dennis

 

 

 

CALCULATETABLE(

  Product,

  Product[Color] = "Red")

1 ACCEPTED SOLUTION

Thank you, it's great helpful for me.  Have a good day. Dennis

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User

No, there is no way to manually insert an abitrary table function into a visual. Doing so would make it impossible to integrate with slicers and crossfilters.

 

For your simple example you could just tick all the columns from the product table and set a filter on Color.

 

In future you will be able to create a paginated report using the XMLA endpoint if you are on a premium capacity, but that functionality is still just in preview. That way you have full control over the queries, but you lose a lot of the interactive features.

Thank you, it's great helpful for me.  Have a good day. Dennis

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.