The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a data set that has snapshots of forecasts. As you can see in the screenshot below, we have forecasts of the same dates, 1 Feb, 1 March, 1 Apr, 1 May at different points in January.
I want to make a plot that compares two snapshots, one in the past and a later one. This is easy to do by creating a new column that links the category and snapshot date (see above). This makes the plot I am after, but the colors are all different and make it hard to read.
Manually changing the colors won't work since the dates will always be changing, so the solution needs to be dynamic.
I want to dynamically give the older date one color and the newest date another color so comparisons are easy, for example I did this below.
I tried creating a measure that gets the min and max date of the slicer selection and use that to make a new column that says Category - Old or Category - New depending on it's asatdate, but that didn't work for me. Open to other ideas, im sure there is a simple fix that I am missing.
Thank you!
Here is a link to a sample file i made:
https://drive.google.com/file/d/1cUyt8vnuyfNKWDCOdynAqSnFPiS57GZH/view?usp=sharing
Yes, but if I create a column that classifies the before and after date, then I can use that in the legend field right?
User | Count |
---|---|
74 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |