Forum Discussion
Chart in Power BI
- Anonymous2 years ago
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 TeamIf 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 Anonymous ,
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