- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Conditional Format column chart based on separate date table
Hi everyone,
I have a basic column chart with a date table on the x-axis, and values on the y. The end user can select to view different charts using the "Ramp" slicer. For each of the values in the Ramp field, there is a separate table consisting of a single specific Transition Date per ramp. I'd like to colour the columns on the main chart so that if the dates are before the Transition Date, they have a different colour, resulting in each Ramp having it's own colour pattern.
Any ideas? Appreciate any insight!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Ben_Cates
Below is the solution
Steps :
1) create a measure
3) after clicking on fx in fromat style select field value and below that select the previously created measure.
add more conditions and colour accoding to your choice in measure.
Below is the file link :-
Dummy data solved
If you get some value Please Kudo's our effort and Accept it as solution so other can be benefited.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please share dummy data or file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here's a link to the dummy .pbix. And a better screenshot below of what I'm trying to achieve.
Both ramps have monthly values from January 2023 through September 2024. Calgary has a separate transition date of May 1, 2024, so every column prior to that on the chart needs to be a different colour. When a user slices the chart to display Edmonton, which has a transition date of July 1, 2023, the chart needs to update the formatting so that every column prior to July 1 has a different colour.
https://drive.google.com/file/d/1One0TErghoLo79Mw6CE0BV90PG8BPg4H/view?usp=sharing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Ben_Cates
Below is the solution
Steps :
1) create a measure
3) after clicking on fx in fromat style select field value and below that select the previously created measure.
add more conditions and colour accoding to your choice in measure.
Below is the file link :-
Dummy data solved
If you get some value Please Kudo's our effort and Accept it as solution so other can be benefited.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
05-27-2024 05:37 AM | |||
06-15-2023 03:04 AM | |||
08-09-2024 01:24 AM | |||
07-16-2024 02:25 PM | |||
01-03-2019 03:23 AM |
User | Count |
---|---|
113 | |
76 | |
56 | |
55 | |
43 |
User | Count |
---|---|
183 | |
120 | |
80 | |
67 | |
57 |