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 StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
11-19-2024 09:55 AM - last edited 11-20-2024 06:54 AM
With error bands in Power BI, the implementation of adding vertical reference bands is quite easy. The key lies in two DAX formulas in order to obtain multiples reference bands that could be either adjacent or non-adjacent to each other. Many thanks to Parvinder Chana for his approach on highlighting data points based on slicer selection. Also, many thanks to the FRED charts for the inspiration.
You can download the pbix file below. Feel free to poke it.
eyJrIjoiM2IzZjJhNzUtZGI5NC00YWE5LWFkZDAtN2JmYzRjMmUzMTc5IiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9