FT Visual Vocabulary - Power BI Edition 01-10-2020 00:48 AM

[SqlJason]

A reproduction of the Financial Time's Visual Vocabulary poster in Power BI. Link to the download file as well as additional details here - http://sqljason.com/2018/12/financial-times-visual-vocabulary-power-bi-edition.html

eyJrIjoiMDA4YWIwZWEtMDE3ZS00YmFhLWE5YWMtODFlZWEzNTU1ODNiIiwidCI6IjZjMGE1YjljLTA4OWEtNDk0ZS1iMDVlLTcxNjEwOTgyOTA0NyIsImMiOjF9

[technolog]

How to create lollipop? Is it custom?

[Anonymous]

Hi Jason,

Thank you for your awsome work, your report is amazing and very useful.

In your line and stackbar chart ("Change Over Time" page), you put the Year & Quarter simultaneously in the X-axis.

I tried this on my own but not sure how you've done it nicely in Power BI, would you please guide me through?

Thanks!

Best regards,

Emily

[brenda_k]

Hi emily, i had the same problem too but managed to get an answer. 

You have to disable the concatenate labels in the formatting section under x-axis, assuming you have the year and quarter fields. 

Here are some links that might be useful: 

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-feature-summary/#hierarchicalAxis

https://community.powerbi.com/t5/Desktop/concatenate-Labels-does-not-work-properly/td-p/415010

[Anonymous]

Hi Brenda,

I've tested it on my files and it works perfectly now.

Thank you so much!

Best regards,

Emily