Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedJoin us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now
In any reporting project, access to data is not enough.
Once you are arrived on the Office Store, enter « pulse » in the search bar, then, once the visual is proposed, click on « Add ». You imported successfully the visual. You can now use it in order to create graphs with beautiful tooltips.
ToolTips are relative to Date & Company Name
The Pulse Chart visual has locations for its 6 different fields.
All these fields allow a complete customization of the visual, but the result is already excellent with only 3 fields.
For ourselves, we will need to use :
Let’s go back to our data model. To feed the field Events with key milestones, nothing really difficult. That could be done using simple conditional columns in Power BI.
An example of rules that could be created by the conditional column :
IF [Date] = June, 29th 2007 AND IF [Company] = "AAPL"
THEN "Apple Founder & CEO Steve Jobs introduces the iPhone"
Let's check that :
Creation of a new custom column
In our data model, the fact table contains a column with the name of several companies, that we will call [Company], and a Date column that we will call [Month].
The idea is to identify some important dates for each company, and then to display the “Key Milestones” to these dates only, for related companies only.
This is a double instruction. Unfortunatly, conditional columns do not support double instructions, but only single ones.
Thus, we are obliged to create a custom column in the query editor.
click here
Syntax is of that kind :
Power Query (M) syntax of the custom column
Just a little "else null" in the end of the code will help us not to have any syntax error.
write "else null" not to have any syntax error
You now have created beautiful dashboard to do some story telling !
Thank you,
Augustin de la Fouchardiere
Senior Business Intelligence Consultant
Former consultant at Société Générale, CGI, Banque de France.
Pulse Chart looks nice, don't you think ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.