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.
Hi, I would like to compare actuals vs budget by using a visualisation. My problem comes with my data.
As you can see, I have a versiojn column which has thousands of rows containing either ACT or BUD, which is tied to values column. I am wondering if it is possible to somehow create two additional columns: one for filtered ACT values and one for BUD. That way, when trying to use a visualisation such as gauge, I can try displaying the different values rather than what happens below.
Open to other suggestions of visualizations too. Thank you for the help
Solved! Go to Solution.
This should be relatively easy to do, and you have already pretty much explained it to yourself!
Just create two Conditional Columns (one for BUD, one for ACT). In the ACT one, if Version = ACT then [values column] else 0. Do the same thing for the BUD column, just checking for the value "BUD" this time. You should then have the columns you need to finish the job.
This should be relatively easy to do, and you have already pretty much explained it to yourself!
Just create two Conditional Columns (one for BUD, one for ACT). In the ACT one, if Version = ACT then [values column] else 0. Do the same thing for the BUD column, just checking for the value "BUD" this time. You should then have the columns you need to finish the job.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |