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 the rigt side there is what i want.

Is it possible to do this in Power Bi Desktop?

 

Thanks, have a nice day

R.

Need Help

3 Replies

  • 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.