Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a data set that looks a bit like in the screenshot below. I have also a link to my drive.
The dataset is upload to Power Query, then to Data model. Using DAX And PowerPivot the end goal is to have two columns:
This way it will visualize the difference between the tax and non-tax, so to speak.
In PQ I inserted a custom column with only the value one. Now, using the chart functionality in PowerPivot I am trying to build the chart and I just picked up and dragged legends below the chart. Just wondering if there is not a better way then to drag the legend as at some point I want to build this in Power BI.
Thanks,
Naveen
Solved! Go to Solution.
Hi @naveen73 ,
I am sorry to inform you that I do not have permission to access the pbix link you provided, but I have applied for access. Please grant me access.
I created the sample data from the screenshot you provided and added a column full of 1's.
Unpivot CustomTax and Tax.
Click close and apply.
Drag year into the Slicer visual and select dropdown format.
Select the clustered column chart, drag Attribute to the X axis, drag Value to the Y axis, select Average aggregation, and then drag Attribute to legend.
pbix file is attached.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi @v-huijiey-msft ,
This is the solution. Actually, when I started with this excercise I wanted to know if inserting the column with 1 is good practice.
What do you, or others, think?
Thanks,
Naveen
Hi @naveen73 ,
I am sorry to inform you that I do not have permission to access the pbix link you provided, but I have applied for access. Please grant me access.
I created the sample data from the screenshot you provided and added a column full of 1's.
Unpivot CustomTax and Tax.
Click close and apply.
Drag year into the Slicer visual and select dropdown format.
Select the clustered column chart, drag Attribute to the X axis, drag Value to the Y axis, select Average aggregation, and then drag Attribute to legend.
pbix file is attached.
If you have any further questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |