Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have one table that contains 13 (static countries) rows for each week. I need to report all those rows every week, however, sometimes happen that I don't have data for some country, however, I still need to show the whole table with 13 rows per the week.
Is it possible to create a pattern static table where I would link the dynamic table, and if there are no values for the specific rows it becomes blank but it will be visible?
See pictures, the first one is the static pattern I need to show in the second table, as you can see there some countries missing due to lack of data.
I need to create dynamically so I don't have to copy-paste 52x13 rows (as I need for the whole year).
Thanks
Solved! Go to Solution.
Hi @vojtechsima ,
Please create 3 tables.
1. 13 countries
2. week:
table 2 = GENERATESERIES ( 1, 52 )
3. crossjoin table:
Table 3 = CROSSJOIN('Table','table 2')
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @vojtechsima ,
Please create 3 tables.
1. 13 countries
2. week:
table 2 = GENERATESERIES ( 1, 52 )
3. crossjoin table:
Table 3 = CROSSJOIN('Table','table 2')
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@vojtechsima , Create a separate country column and join this table with that and try this option or add +0 to the measure
countrows(Table)+0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |