Hey everyone,
I am confronted with a problem, to which I could not really find an appropriate solution. I will try to simply my question.
So I have a table with the following columns:
Country,
Month,
Expenditure,
CountryExpCummu. (This is a DAX column where I calculate the monthly cummulated sum of Expenditure of each country),
AllExpCummu. (This is a DAX column where I calculte the monthly cummulated sum of Expenditure of all the countries)
Then, I want to visualize these data in bar chart and here is the function I want it to fulfill:
I add the [Country] column as the slicer, [Month] as the x axis . When I choose a specific country in the slicer, the y axis will show the maximum of the values in [CountryExpCummu.] in each month ; When I don't choose any country in the slicer, the y axis will correspondently show the maximum of values in [AllExpCummu] in each month.
(Here is the thing that might need attention: Since each country has multiple expenditures in each month, therefore, when I calculate the cummulated sum of each country in [CountryExpCummu.] as well as of all countries in [AllExpCummu.] , some same values will be shown in every line that contains the same country and month. That is why I mention that I want the y axis only to show the maximum of relevant value of each country in each month, not the sum)
Would anyone be kind enough to provide me with an solution? This is sort of like "dynamically changing the axis value" problem but not exactly the same since the x axis remains the same, which shows [Month] from beginning to the end while y axis switches dynamically between two columns based on the choice in the slicer.
