Share via

Create a clustered bar chart with icon y axis in Power BI

Mahnaz Haghighi 40 Reputation points
2024-10-20T05:31:14.06+00:00

Hi. I have a hotel dataset and it has a column named 'Review Rating' that its values is numbers 1 to 5(for its stars). I want to create a clustered bar chart in Power BI that its y axis is shown with stars. for example for Review Rating 1 shows one star and for Review Rating of 3 shows three stars. Can you help me?Capture.PNG

Community Center | Not monitored
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-21T04:38:02.3+00:00

    Hi Mahnaz Haghighi,

    Thank you for reaching out to us on the Microsoft Q&A forum.

    To achieve the desired effect of displaying stars instead of numeric values for the 'Review Rating' column in your dataset, please follow these steps:

    1. Replace Numeric Values with Star Symbols:
      • Select the 'Review Rating' column.
      • Go to Home > Transform > Replace Values in Power Query.
      • Enter the numeric value to replace (e.g., "4") and input the corresponding star rating (e.g., "****" for 4 stars).
      • Click OK to confirm the changes.
    2. After making these changes, load the data back into Power BI.
    3. Now, you can create a Clustered Bar Chart and set the 'Review Rating' column (with stars) as the y-axis. This will allow you to visually represent star ratings in the chart.

    Kindly refer to the attached screenshots for detailed guidance.User's imageUser's image

    If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

    If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members.

    Thank you.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.