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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Randalnik
Frequent Visitor

Table - group by visualization

Hi,

 

I would like to ask you for help. I have table with many columns and i want to re-organize the visualization, see below for example:

TYP.PNG

On the left side there is the current situation, on the rigt side there is what i want.

Is it possible to do this in Power Bi Desktop?

 

Thanks, have a nice day

R.

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

Hi @Randalnik,

 

In Power BI desktop version 2.48.4792.721 64-bit (July 2017), you can create a matrix visual, place both the TYPE and COLOR columns in Rows property, turn off the Stepped layout OFF. You can download attached pbix file.  

 

q5.PNGq6.PNG

 

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-qiuyu-msft
Community Support
Community Support

Hi @Randalnik,

 

In Power BI desktop version 2.48.4792.721 64-bit (July 2017), you can create a matrix visual, place both the TYPE and COLOR columns in Rows property, turn off the Stepped layout OFF. You can download attached pbix file.  

 

q5.PNGq6.PNG

 

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-qiuyu-msft,

 

Thanks for your fast help! I would like to ask you one more questiono.

 

I have been solving problem with conditional formating text in table (its impossible to do this) but i had found some sick solution.

Anyway my status is following:

I have main table with data (name, adress... and some values in (-1,1) and small tables constist of 2 columns: value (-1,1 >>> its connected to main table) and images (Y,N). I have created table with these atributes (name... Y/N) but these pictures show as big but they are very small, see below:

HELP.PNG

Is there any optin how to setup the size of pictures in POwerBI (data category: Image URL) ? I cant create smaller N/Y (has cca 40x40 pixels)

 

Thanks, have a nice day,

R.

Anonymous
Not applicable

 

Hi,  I was going through this post today and Thought to share the details if it helps to get to the solution. Refer the below link.

http://nisalbi.blogspot.com/2018/01/how-to-visualize-images-dynamically.html

 

Refer the link (  https://www.iconsdb.com ) to download the popular icons with different sizes (16*16   or   24*24   or   32*32   or   48*48   or   64*64   etc.)

 

 

Thank you.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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