Forum Discussion

enoch99's avatar
enoch99
Helper I
3 years ago
Solved

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 ...
General Comment
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    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's avatar
Jihwan_Kim
Super User
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.

enoch99's avatar
enoch99
Helper I
2 years ago

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