Forum Discussion

Randalnik's avatar
Randalnik
Frequent Visitor
9 years ago
Solved

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: On the left side there is the current situation, on...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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.  

     

     

     

    Best Regards,
    QiuyunYu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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.  

 

 

 

Best Regards,
QiuyunYu

  • Randalnik's avatar
    Randalnik
    Frequent Visitor
    9 years ago

    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:

    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.