How to populate Table visual

[DonPepe]

Hi, 

I would like to have some explanation about how to work with table visual in my report. 

I modeled my data like a star schema with my fact table in the centre. 

Along my report, I have plenty of table visual to show various information about the company.

Like all of the last week employee or timesheet/employee, etc

My current solution to populate my table visual is to create new table in my modele with SUMMARIZE and/or GROUPBY but at the end I have a lot of table and I am not sure that is the right way to do it. 

Wath is your thought about that ? 

Thank's for your help,

Don 

[DonPepe]

Hi @amitchandak,

Thanks for the answer, I don't really have example for the moment. It's more to have a know how. 

Create measure to populate a matrix visual, it's ok. But I am struggling creating measure to populate a Table visual. I always have the error : "A Table of multiple values was supplied where a single value was expected"

So I create new table in the modele to avoid that. 

Do you know where I can learn more about that ?

Have a nice day,

Don

[amitchandak · Accepted solution]

@DonPepe , Ideally you should create measure and use that in table and matrix visual.

All visual groups or aggregate the data.  New table should be created only when you are not able to achieve it using visuals

Can you share the specific need?