Show Different type of Data in Same Visual In Power BI

user_6270968 0
Viewed 398

I have a scenario where I have a column in a table which is having multiple project list. And each project is of different type. And the types are for ex FP and T&M. Now as we can see in First image , Charge Ratio is showing for FP type Projects and Second Image showing Bill Utilization for T&M ProjectsNow as we can see in First image , Charge Ratio is showing for FP type Projects.

.and Second Image showing Bill Utilization for T&M Projects

My Requirement is ,I want to show both The Charge Ratio and Bill Utilization in One Visual According to the Project Type. I have a slicer which user can choose the projects. If the choosen project is T&M type then it should show visual according to that type. If it is FP then in that line chart only, i would like to show the visuals according to that type.

Note:- I don't want to use the slicer for TYPE selection

Please Give me suggestion.

Thank You.

powerbi
2 Answers

I recommend utilizing Bookmarks, a button, and visibility controls to toggle visibility between two different charts.

Go to view and check Bookmarks Pane and Selection Pane. Add two copies of your chart, two bookmarks, and Home >> Button twice.

All assets are nested on top of each other. Save one bookmark with a button visible and the other hidden. One chart visible, and the other hidden. Save the other the opposite way. Make sure to name all of your assets so you can keep track of them. Go to your bookmark and update it.

Click your button and go to Action and turn it on, set both to opposite bookmarks.

Final state will have a button that switches to the other bookmark, and one that flips back to the first. One will turn off the chart for FP and turn on the T&M, and the other will turn off T&M and turn on FP.

user_113758680
Related