more effective visualization

[jcamilo1985]

Good evening Experts

Now I have been more active than a long time ago, it is while I return to practice. 😁

I have the following table in a report, I want to know if someone knows another way to visualize this information that is more aesthetic, that is, the table compares all the values by means of the color gradient, there is another visualization that allows me to do this in a way more attractive, Or is this the best way?

I listen to opinions, thank you very much for your help

[Anonymous]

Hi @jcamilo1985 ,

It is undeniable that using Conditional Formatting does make it easier for users to find trends.

In my opinion, since there's Date in your data sample, you could try to calculate the differences between current month and last month.

differenceMethod =
VAR _app =
    SELECTEDVALUE ( 'Table3'[Region] )
VAR _yearmonth =
    SELECTEDVALUE ( 'Table3'[YearMonth] )
VAR _lastmonth =
    CALCULATE (
        SUM ( 'Table3'[Per] ),
        FILTER (
            ALL ( 'Table3' ),
            'Table3'[Region] = _app
                && 'Table3'[YearMonth]
                    = CALCULATE (
                        MAX ( 'Table3'[YearMonth] ),
                        FILTER ( ALL ( 'Table3' ), 'Table3'[YearMonth] < _yearmonth )
                    )
        )
    )
RETURN
    IF (
        _lastmonth = BLANK (),
        MAX ( 'Table3'[Per] ),
        CALCULATE ( SUM ( 'Table3'[Per] ) - _lastmonth )
    )

My visualizations looks like this:

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[PaulDBrown]

@jcamilo1985 

One thing I would definitely do is to change the column headers to MMM YYYY (or even MMM YY) where month is text. 
I actually think the gradient works because it depicts a sense of progression. If, however, you prefer to focus attention you could set a measure for % Thresholds and use that to highlight. Or use an average to compare values with.

it really depends on what you want to highlight, but ideally it should be clear at a first glance. A good test is to get someone who hasn't seen the chart to take a look and ask what she/he thinks the chart depicts and what conclusion derives from it.

[AllisonKennedy · Accepted solution]

Depends on what you want to focus on and do you only have all 7 Regions? I like the ribbon chart to compare relative values - sort the values of each date so you can see who is at the top for each month and how many positions they changed. https://docs.microsoft.com/en-us/power-bi/visuals/desktop-ribbon-charts