Create multiple table visuals from one dataset

[enoch99]

Hi everyone,

I have a master data of sales for different years and I wanted to create a table visual for each Year separately. Is there a way to use the same data for multiple table visuals without creating new filtered tables. I also do not want to have a 'Years' column as I will use the year as a title of each table visual.

Thank you

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

[enoch99]

@Jihwan_Kim Thank you for your quick response. I found your solution very useful, but I have one question - what if some of the products do not have sales in specific year and I don't want to show them on the table. For example, if Prod03 and Prod04 don't have  any sales in 2020 and I don't want to show them.

[Jihwan_Kim · Accepted solution]

Hi,

Thank you for your message. In my opinion, if the sales amount of a certain product is blank, then the result is blank = it will not show in the visualization. 
Or, if you are refering to the different datamodel, please share your sample pbix file's link here together with how your desired outcome looks like, and then I can try to look into it to come up with a better solution.
Thank you.

[enoch99]

You are right. It was a problem with my data model and it worked like you said when I corrected it. Thank you.