problem of dynamic axis chart

---

shashank wrote:

 

Problem: Dynamically change the axis- So there is a drop down of axis type (Market/Country). Based on the selection, the Y-axis should change. So if Market is selected then graph should display sales across markets- NAM, APAC, etc. and if country is selected then graph should display sales across countries. We have 2 separate columns for market and country in data ?

---

shashank

There's no such feature in Power BI, however I think you could do it with some tricky measure. You can put this measure to the value field of the chart and it would vary according to the country/market slicer.

measure =
IF (
    ISFILTERED ( 'slicerTable'[countryOrMarket] )
        && HASONEVALUE ( 'slicerTable'[countryOrMarket] )
        && LASTNONBLANK ( 'slicerTable'[countryOrMarket], "" ) = "coutry",
    [your measure for country],
    [your measure for market]
)