how to segment percentage wise values from the table?

[dinesharivalaga]

Hi All,

I want to get a partition of my percentage values from the table .

for example i want to create a pie chart for the below % values like 10 to 30% , 30 to 50% & 50 to 80% 

Based on this segments i will show the total counts under those segments covered in the pie chart.

Below the data from my table :

here 28% means it wil come under 10 -30% segment .

Like wise i want to split it .

Please help to sort this scene ..

Thanks

DK

[v-rongtiep-msft · Accepted solution]

Hi @dinesharivalaga ,

Please have a try.

Create a column.

Column =
IF (
    ( 'Table'[YTD CM%] ) > 0.1
        && ( 'Table'[YTD CM%] ) <= 0.3,
    "10%-30%",
    IF (
        ( 'Table'[YTD CM%] ) > 0.3
            && ( 'Table'[YTD CM%] ) <= 0.5,
        "30%-50%",
        IF (
            ( 'Table'[YTD CM%] ) > 0.5
                && ( 'Table'[YTD CM%] ) <= 0.8,
            "50%-80%",
            BLANK ()
        )
    )
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Ashish_Mathur · Accepted solution]

Hi,

I have solved a similar problem in the attached PBI files.

[v-rongtiep-msft · Accepted solution]

Hi @dinesharivalaga ,

Please have a try.

Create a column.

Column =
IF (
    ( 'Table'[YTD CM%] ) > 0.1
        && ( 'Table'[YTD CM%] ) <= 0.3,
    "10%-30%",
    IF (
        ( 'Table'[YTD CM%] ) > 0.3
            && ( 'Table'[YTD CM%] ) <= 0.5,
        "30%-50%",
        IF (
            ( 'Table'[YTD CM%] ) > 0.5
                && ( 'Table'[YTD CM%] ) <= 0.8,
            "50%-80%",
            BLANK ()
        )
    )
)

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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