Forum Discussion
Table visual problem - an intriguing one
Hi, I have attached a data table and the corresponding visual. I need to be able to visualise the table so its values do not double up as it can be seen above. Matrix Visual does...
Hi magyar,
Based on my assumption, I created a simplified data table like below which resulted in duplicate records in table visual.
What you desired should be similar to below visual, right?
If so, you should create a calculated table that has removed duplicate rows. Then, you can directly drag fields from this new table into visual.
Table = SUMMARIZE ( SourceTable, SourceTable[Project Name], "July", LASTNONBLANK ( SourceTable[July], 1 ), "Aug", LASTNONBLANK ( SourceTable[Aug], 1 ) )
Best regards,
Yuliana Gu