Hi-
New user and of course lots of questions!
I currently have data that looks like this-
The fee is earned 50% on date.1 and 50% on date.2.
The data has to be able to graph so that it shows 50% on date.1 and 50% on date.2
How can I show this in the data? My first thoughts were something that looks like this below but I do not know how to manipulate into this format.
Any help would be appreciated!
-C
Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .
Change the name to New Fee 3.
Enter The following Formula 4:
=[Fee]/2
Now you can delete the original column Fee.
Highlight both date colunms. On the Transform tab, click Unpivot Columns.
It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.
*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!
Open advanced editor. With your Query, go to the " Add Column" 1 tab and click "Custom Column" 2 .
Change the name to New Fee 3.
Enter The following Formula 4:
=[Fee]/2
Now you can delete the original column Fee.
Highlight both date colunms. On the Transform tab, click Unpivot Columns.
It will give you two new columns, Attribute and Value. You can delete Attribute*, rename Value as Date.1/Date.2, and rename New Fee as Fee.
*Also, if you wanted to know if it was date 1 or date 2 then do not delete attribute!
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
