Forum Discussion
Create multiple table visuals from one dataset
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.
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.
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.
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.You are right. It was a problem with my data model and it worked like you said when I corrected it. Thank you.