Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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