P01 - Directed Dot Plot
carlosbarboza - great visuals mate! I've tasked myself to recreate these visuals to up my PBI game and I started with the 'directed dot plot'. Having gone through your PBIX file, I haven't been able to recreate the dot plot (thin lines) for some reason. I know the chart is based on the clustered bar chart but how have you transformed it to the dot thin lines ... I can't see anywhere in the visual format where you did that. What I'm I missing?
Hello 3rdSun , basically the trick lies in the Error bars option (number 3 in the image below)
Now in order to get the "line", you need to insert a measure for the values which are being compared to the current values (step 1 on the image above). I have renamed the measure to "units 2019" or step 2. Then go to the Error bars option (step 3) and on the "Apply settings to" (step 4), select this renamed measure (units 2019). Then on the Options sections, activate or enable it by toggling the button to On. Now step 5, is about placing the measure of "04 dot_2020" on the upper bound slot (pointed by red arrow) which is a conditional formula to check if the current values are greater than the values being compared (previous year on this case), so if the current is greater than prior then plot the current values. With this logic, you get to plot the "thin line", as seen on the image above (step 6) after toggling on the option of "Bar", and you can also visualize the circled end markers by activating or switching the Markers option (step 7) on the toggle button to On.
Repeat this process for series: 2019 or DAX measure 02 sales_19 (renamed to 2019). But remember for this series to be formatted you will need another conditional DAX formula, which for this example it is 05 dot_2019.
Hope these steps and image help.
