I have the data represented in the below excel format.
Now I want to represent the Excel table in status bar chart by quarter in PowerBi as shown below. I have a Region filter in powerbi dashboard.
Ideally, depending on the Region filter the Power Bi graph values should be changed accordingly.
But here the issue is when we are selecting a specific region, we are able to show the same values as in Excel, but when we are selecting the option as ‘SELECT ALL’ in the filter the graph values are not giving the correct values as per the excel sheet in the ‘Project Status Trends’ section.
Please find the above provided screenshots and let me know if you could assit with this request ASAP.