Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
01-02-2020 14:00 PM
This is a mock-up in response to this question on the Power BI Community Boards and provides a concept for expansion rather than telling a particular story. This is an example building on Parker Stevens' excellent Dynamic Reference Line on X-Axis walkthrough, with a twist.
Rather than having a single line, this uses a date range to shade a specified range of values, via the Date Range slicer below. This is managed using a disconnected date table for the slicer, as per Parker's version, and the only difference being we set the measure for the column field to be BLANK() if it falls outside the specified range. This makes the column chart portion of the visual appear 'filled in'.
There's an addition of an Outer Threshold (%) parameter, which then uses conditional formatting to set the inner/outer colour based on the percentage specified in that slicer.
If exploring the workbook, everything you need to explore and remix is in the Reference Line Slicer and Banding Theshold tables, in addition to the orginal video.
eyJrIjoiZGJlOGZkOTQtMjAzYi00OWExLWIyMDQtMzE5ZDI3NzcxODhkIiwidCI6IjUzYmJlMGQ3LTU0NzItNGQ0NS04NGY0LWJiNzJiYjFjMjI4OSJ9
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)