can i customize the color displayed in the bar chart in Real time dashbaord in Fabric

[sshetty014]

Hi I have couple of questions with Real time dashboard in fabric

1. I am looking for a solution where i can swap the color of the bars in my below bar chart. In the Visual i couldnt find any settings to do so, also programatically i was not able to find a solution for it . I tried using Hex Code but that did not help

2. If you see the above legend I can see that it displays QueryStatus:Cancelled:Percentage , but I dont want to show Percentage keyword in the legend , how to achieve this.
below is the query Im using for the above chart 

let lookup = silver_customerqueries

| join kind=inner external_table('querytypes') on QueryTypeID

| join kind=inner silver_querystatuses on QueryID

| extend QueryStatus = case(

    QueryStatus in ("In Progress", "New", "Escalated"), "Unresolved",

    QueryStatus

)

| project QueryID, OrderItemID, QueryTypeID, QueryType, QueryStatus;

lookup

| summarize Count = count() by QueryType, QueryStatus

| join kind=inner (lookup | summarize TotalCount = count() by QueryType) on QueryType

| extend Percentage = round(100 * Count / TotalCount, 2)

| project QueryType, QueryStatus, Percentage

[v-prasare · Accepted solution]

Hi @sshetty014,

Thanks for reachig MS Fabric community support.

 1. Fabric’s Real-Time Dashboard doesn’t provide direct color customization in the UI. However use Power BI Desktop to create and customize your real-time dashboard, follow these steps to find the Format Visual settings:

Step 1: Open Your Power BI Report

Open Power BI Desktop > Load your dataset (either from Fabric Real-time Streaming or any other source) > Select the Stacked Bar Chart (or the chart you're using for your real-time dashboard).

Step 2: Open the Format Visual Pane

Click on the visual (your bar chart) > On the right-side panel, look for the Visualizations pane > Click on the paint roller icon (this is the "Format Visual" button).

Step 3: Change the Data Colors

Scroll down in the Format Visual pane  > Find the "Data Colors" section > Click on each category (QueryStatus:Cancelled, QueryStatus:Closed, etc.) > Choose a custom color for each category.

Step 4: Save and Publish

After setting the colors, Save the report  > Click Publish to upload it to the Power BI Service. > If using Fabric Real-Time Dashboard, ensure your dataset is connected.

 2. The legend displays field names exactly as they appear in your dataset. To remove Percentage, you need to rename the column dynamically in your query. Try modifying your final projection:

lookup
| summarize Count = count() by QueryType, QueryStatus
| join kind=inner (lookup | summarize TotalCount = count() by QueryType) on QueryType
| extend Percentage = round(100 * Count / TotalCount, 2)
| project QueryType, Legend = strcat(QueryStatus, ""), Percentage

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query