Forum Discussion
Solved
more effective visualization
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 vi...
- 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
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