Table visual problem - an intriguing one

[magyar]

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 doesn't do image URLs hence the Table Visual. 

Please let me know if you know of any settings that can make this happen, I have done it in the data model but it requires a lot lot of extra steps plus it is hard to do an auto refresh that way too.

Many thanks.

[v-yulgu-msft]

Hi @magyar,

Have you worked out it? If yes, would you please accept the helpful reply as an answer or share your solution so that it can benefit more users? If you still have any question, please feel free to ask.

Thanks,
Yuliana Gu

[v-yulgu-msft]

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

[GilbertQ]

Hi @magyar

What you could try is in the Query Editor to Add in a new column, and give it any name and any value. This is just so that you have got another column in your data.

Then right click on your new column and select 'Unpivot Other Columns'

This will then unpivot your data where you will now have your months and data on the rows.

Now Remove the column you created above in the first part.

That should then load to your data model where you can view it as you required as per your second image.

[magyar]

Hi guavaq

Thanks so much for taking the time and looking at the this.

I have done the workaround you have suggested before and it functions fine, you are right however i am after something more intuitive, more straight forward if you know what i mean because I have to update the data from time to time, a process that I would like to automate too.

[GilbertQ]

Hi @magyar

That process will work everytime you update the data. All the steps that you have in the Applied Steps in the Query Editor will be run each and every time you refresh the data. So that should then automate your process?