Need help with Visualizations

[ElioAngarita]

Hello, i'm a new user of Power BI and i'm just learning as i go.

This report is based on customer service resolution time.

Currently i'm having issues with some visualizations, i hope you can help:

1) Here i had to create a Custom Group so i could organize my data the way i wanted. Now, i just want to show the total % of the 5+ days category (which has data from 5 days to 16 days)(red color). Currently it's showing the percentage individually.

2) For the next chart i have 2 questions:

a) Is there any way you can use a slicer for a speceific chart, not for the whole report?

b) How do i change the date format? On the query editor i already changed the date column to DATE (MM/DD/YYYY). But as you can see over here, the chart is showing a format with text and numbers that i dont want.

Thank you so much for your answers!

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I create a table to test:

Then, I create two columns to calculate its time taken and category:

Time Taken = DATEDIFF('Table'[Created Time],'Table'[Solved Time],SECOND)/(3600*24)

Category =

SWITCH (

    TRUE,

    'Table'[Time Taken] > 0

        && 'Table'[Time Taken] <= 1

        && DAY ( 'Table'[Created Time] ) = DAY ( 'Table'[Solved Time] ), "0 days(Same day)",

    'Table'[Time Taken] > 0

        && 'Table'[Time Taken] <= 1

        && DAY ( 'Table'[Created Time] ) <> DAY ( 'Table'[Solved Time] ), "0 days(different day)",

    'Table'[Time Taken] > 1

        && 'Table'[Time Taken] <= 2, "1 day",

    'Table'[Time Taken] > 2

        && 'Table'[Time Taken] <= 3, "2 days",

    'Table'[Time Taken] > 3

        && 'Table'[Time Taken] <= 4, "3 days",

    'Table'[Time Taken] > 4

        && 'Table'[Time Taken] <= 5, "4 days",

    'Table'[Time Taken] >= 5, "5+ days"

)

And the result shows:

For your 1) question, I think the you may add another category field in Details just like [Service ID] in my test table:

When only choose [Category] and [Time Taken], it shows the total %:

For your 2)a) question, you can use ‘Edit interactions’ function to disable other visuals and enable specific visuals you want:

For your 2)b) question, you have only changed data type to (MM/DD/YYYY), you should continue to change its format after Close&Apply Query Editor:

Here is my test pbix:

pbix 

Best Regards,

Giotto Zhi

[I_Like_Pi]

Nest your resolution calculation in a min function

Resolution = MIN(   your current calc    , 5)

2 a) Click the slicer,  go to the Visual tools / Format ribbon tab, Select Edit interactions menu item.   All the other visuals will have a filter icon and a do not icon. 

2 b) On the left you should see visuals/data/relationship as icons, click the data icon (it looks like a little table).

From the right pane select the table that has the date field you want to "model". Now select the field header. From the modeling ribbon tab select the Format drop down and make your selection.

edited for spelling