problem of dynamic axis chart

[shashank]

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 ?

[Eric_Zhang · Accepted solution]

---

@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]
)

[danextian]

I wrote a similar post. This might be what you need http://community.powerbi.com/t5/Desktop/Dynamic-Category-Using-a-Slicer/m-p/216971#M96101