Forum Discussion

naveen73's avatar
naveen73
Helper III
2 years ago
Solved

Chart in Power BI

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 go...
  • Anonymous's avatar
    Anonymous
    2 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 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!