Forum Discussion
enoch99
3 years agoHelper I
Create multiple table visuals from one dataset
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 ...
- 3 years ago
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.
Jihwan_Kim
3 years agoSuper User
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.