Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
magyar
Frequent Visitor

Table visual problem - an intriguing one

Hi,

 

I have attached a data table and the corresponding visual.

 

Table.PNGTableVisual.PNG

 

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.

5 REPLIES 5
v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @magyar,

 

Based on my assumption, I created a simplified data table like below which resulted in duplicate records in table visual.

1.PNG2.PNG

 

What you desired should be similar to below visual, right?

3.PNG

 

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 )
)

 

4.PNG

 

Best regards,
Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.

 

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.