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
Marijn514
Regular Visitor

Trying to find/create a certain visual to use in powerbi.

Hello experts,

 

I'm quite new to Power BI Desktop and I'm loving it. However, I'm having trouble with something that might be very easy for many of you.

 

I'm trying to figure out how to make a clean table visual like the following:

Marijn514_1-1716905388757.png

 

I can notice that the bold part is the title of the visual, but I can't figure out how to recreate this.

When hovering over it with the cursor, only the right side (named "Inkoopmedewerker" to "Parttime") is highlighted; the left side stays fixed. This is how I'd like to show my data as well.

I have tried creating a table visual and other visuals, but my data is displayed horizontally next to each other. It feels like I'm missing something that I can't identify.

I hope you understand my question and can kick me in the right direction.

 

Thank you!

1 ACCEPTED SOLUTION
Marijn514
Regular Visitor

Dear @v-tangjie-msft 

 

I have found the solution! I apologize for the time you spent on me.

What I was looking for was a simple textbox. Within this textbox, I could write the names of the information I needed to show from my queries.

After doing this, I could simply add a value with the name of my data, and it would display the data I wanted to show.

 

Additionally, I learned something new from you about combining visuals. Thank you for that valuable insight!

 

Marijn514_2-1717075209821.png

 

View solution in original post

3 REPLIES 3
Marijn514
Regular Visitor

Dear @v-tangjie-msft 

 

I have found the solution! I apologize for the time you spent on me.

What I was looking for was a simple textbox. Within this textbox, I could write the names of the information I needed to show from my queries.

After doing this, I could simply add a value with the name of my data, and it would display the data I wanted to show.

 

Additionally, I learned something new from you about combining visuals. Thank you for that valuable insight!

 

Marijn514_2-1717075209821.png

 

Marijn514
Regular Visitor

This is awesome! You've already helped me a lot!

I hope I can explain this correctly. As you can see, I created the table I wanted on the left side. On the right side, I have a table with the input data from my queries. However, the input is generated in a horizontal layout. I tried to draw my idea as an example, showing yellow for what's currently happening and green for how I'd like it to be. Unfortunately, I don't see a "Turn visual sideways" button anywhere.

 

Marijn514_1-1717055691162.png

The whole idea behind this is that when I click a name in another visual containing the employee names, it will filter the specific info about them.

 

please ignore the blank visual for i have used it to block the sensitive info.

 

v-tangjie-msft
Community Support
Community Support

Hi @Marijn514 ,

 

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

vtangjiemsft_6-1716947856245.pngvtangjiemsft_7-1716947865987.png

 

(2) We can create two table visuals.  Adjust the visual object settings as shown below.

vtangjiemsft_1-1716947559238.pngvtangjiemsft_2-1716947593568.pngvtangjiemsft_3-1716947622074.pngvtangjiemsft_4-1716947687577.png

(3) Then the result is as follows.

vtangjiemsft_8-1716948321767.pngvtangjiemsft_9-1716948343215.pngvtangjiemsft_10-1716948360287.png

If I have misunderstood your needs, please clarify in a follow-up response.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

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.