Creating a visual

[Anonymous]

Hello everyone,

I am new to powered, I am working on a sample example.

Can anyone tell me what kind of visual I can use for making the tile shown in the figure below.

Thankyou,

Jyothi.

[Anonymous]

thanks @lin

[v-lili6-msft]

Hi@jyothisai

You can use Conditional formatting in tables like me as below

Step 1:

If the "Percent of Number of" is based on one column that type is Number ,you need to add two columns:

Percent of Number of =
IF (
    Table4[Rate] > 0
        && Table4[Rate] <= 0.2,
    "0%-20%",
    IF (
        Table4[Rate] > 0.2
            && Table4[Rate] <= 0.4,
        "20%-40%",
        IF (
            Table4[Rate] > 0.4
                && Table4[Rate] <= 0.6,
            "40%-60%",
            IF (
                Table4[Rate] > 0.6
                    && Table4[Rate] <= 0.8,
                "60%-80%",
                IF ( Table4[Rate] > 0.8 && Table4[Rate] <= 1, "80%-100%" )
            )
        )
    )
)

Type =
IF (
    Table4[Rate] > 0
        && Table4[Rate] <= 0.2,
    1,
    IF (
        Table4[Rate] > 0.2
            && Table4[Rate] <= 0.4,
        2,
        IF (
            Table4[Rate] > 0.4
                && Table4[Rate] <= 0.6,
            3,
            IF (
                Table4[Rate] > 0.6
                    && Table4[Rate] <= 0.8,
                4,
                IF ( Table4[Rate] > 0.8 && Table4[Rate] <= 1, 5 )
            )
        )
    )
)

 

Step 2:

then add fields "Orgin Airport " ,"Destination" and "Percent of Number of" into visual matrix  

Step 3:

Set Conditional formatting like this :

Note: notice the Settings in my red box

Result:

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft,

You have been very helpful, can you please clarify my last doubt.

I had Number of Flight column

I created a percentage column for number of flights,

Then using If condition as you told i created Percentage of number of and Type columns (table 4= Airport analysis, rate= Percentage)

But i am not getting an aggregate values when i am adding "Percentage of number of columns"

Can you tell me where I am going wrong.

Thanks and Regards,

Jyothi.

[v-lili6-msft]

Hi@jyothisai

when you add "Percentage of number of columns" into values of matrix ,the filed data type is Text ,So it only can be aggregated by Count, Distinct count, First, or Last.

Reference: https://docs.microsoft.com/en-us/power-bi/service-aggregates

Best Regards,

Lin

[Anonymous]

@v-lili6-msftThere is some kind of problem that occured while creating a the columns, they are not values properly.

Where did I go wrong?

Thanks and Regards,

Jyothi.

[v-lili6-msft]

Hi@jyothisai

According to your two pictures，I find that the values of "Percent" and "Percent of Number of" may have no problem, but the colour of the background is wrong, it could be your wrong setting of Conditional formatting, so please check the setting by my picture above and be careful of  Settings in my red box . 

If it is not your case, please share PBIX. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft 

I have mailed you required data, can you please refer and let me know what changes I can make.

Thanks and Regards,

Jyothi.

[Anonymous]

Hi @v-lili6-msft,

I tried creating a new column but it was giving me following errors. CAN YOU PLEASE TELL WHAT CAN i DO TO RESOLVE THESE ERRORS. And where did i go wrong.

[v-lili6-msft · Accepted solution]

Hi,@jyothisai

You just need to be careful about  format of your formula , I have marked your mistake by red box as below:

by the way, if you want to present the cells without the numbers present , you Use font color scale for the column the same way you did the background color scale,

once you do that, font color and background color will be same and you will not see the number but only heat color (background color)

Best Regards,

Lin