Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am facing issues in Power Bi Bar charts when i try to toggle between 2 values of a chiklet slicer. Please find the sample Screenshot attached.
There are 2 phases for each of the project (Current Phase and All Phases). For the below project, we dont have any data for current phase. but when i switch between Current Phase and All Phases, the Bar chart is not disappearing (Because of no data) for the current phase. its still showing the values of "All Phases".
on the Y Axis, we have Discipline name and Status of the project (Completed/not completed)
on the X Axis, Count of tasks.
When i turn on concatenate labels in the properties pane of Y axis, the chart works fine. but if i turn off the concatenate labels, the chart still shows the values of "All Phases" in Current Phase.
Here are the list of criteria to be met.
1. Current Phase = Count of tasks with phase type = "Current Phase" in Project Info table
2. All Phases = Count of all the Tasks of Phase type column in Project Info table (Including Current Phase)
3. Project A doesnot have Current Phase.
4. We want the result to be seen through Bar chart.
5. We dont want to concatenate labels in Y axis of bar chart.
Thanks in Advance!!
Hi @KAC5
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi, Please find the Sample PBIX, and here are the list of criteria to be met.
1. Current Phase = Count of tasks with phase type = "Current Phase" in Project Info table
2. All Phases = Count of all the Tasks of Phase type column in Project Info table (Including Current Phase)
3. Project A doesnot have Current Phase.
4. We want the result to be seen through Bar chart.
5. We dont want to concatenate labels in Y axis of bar chart.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |