Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
You are right. It was a problem with my data model and it worked like you said when I corrected it. Thank you.
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |