User Profile
YYlee
Helper I
Joined 2 years ago
User Widgets
Contributions
Re: Improving Visualization of Multiple Data Points in a Scatter Chart
Dear Ashok, Thank you for your help!! 1. I tried the size measurement before, but unfortunately it doesn't work. If one dot is multiplied by 100, the rest are multiplied by 100 too, so the outcome is the same. 2. My marker colour does not appear [fx]. I am not sure why.Improving Visualization of Multiple Data Points in a Scatter Chart
Hi All, I used a scatter chart to create this, but the sizes of dots 3 & 4 / 5 & 6 look very similar and are difficult to distinguish visually. I tried adjusting the dot sizes using different DAX, but outcome was the same. Is there a way to make the differences in dot size more pronounced, or to automatically apply different colors based on dot size (for example 1= lighter blue, 2 = ...., 100 = darkest), or any ideas to make the whole statement more clear? Value : AngleDeg X Axis : 0X =MAX ( MVPI[Radius] ) * COS ( RADIANS ( MAX ( MVPI[AngleDeg] ) ) ) Y-Axis : 0Y =MAX ( MVPI[Radius] ) * SIN ( RADIANS ( MAX ( MVPI[AngleDeg] ) ) ) Legend : Categories into 1,21,3,4 according to the individual marking Size : 0Dot Size = VAR MaxPax = CALCULATE ( MAX ( [0PaxCount] ), ALLSELECTED ( MVPI ) ) RETURN EXP ( DIVIDE ( [0PaxCount], MaxPax ) * 2 )Actual and Target Sales by Quarter
This is my database I wish I can get like this I link the "Location Name" and "Quarter" between excel 1 & excel 2. However, when I insert those data in BI, cluster column chart and box & whisker looks good, BUT, when I choose Excel 1 - Location Name, Quarter, Net Revenue + Excel 2 - Target Revenue, BI auto sum up the Target Revenue for me which I prefer them to be seperated by different location and quarter so I can compare each of them. Could I look for advice?Re: DAX Questions
Thank you. Q1 solved. Q2 supposed based on Q1+Year 2024 only = Top 5 list. their trend suppose shown from 2020-2024 Q3. May I ask what is a dummy data? I have 4 categories in Year 2024, and they share the same amount of line y-axis based on location. For eg, Group is 40%, Hong Kong is 27%, Shanghai ... Singapore ...But they are not different by the y-axis categories
