Forum Discussion
Dynamic change in X Axis
Hi BI Masters!
I'm fairly new in the world of Power BI and came accross a problem that's puzzling me for quite some time now.
I have a table with columns for Country, Region, City and several numerical values. What I want to do is to create a column chart with drilling option - without drilling. :)
So I'd have 3 slicers (country, region, store) and several IF THEN options. IF nothing is filtered the chart would show data on country level. If country is filtered it'd show data on region level (for the selected country). If region is filtered it'd show data on city level (for the selected country / region). If city is filtered it'd show data for that one city alone.
My first thought was to create a calculated column that'd copy the values from one of the columns based on the ISFILTERED function but because calculated columns are initialized on data load and not on user interaction it wouldn't work.
So here's my question: is it possible to create something like this?
Warhawk wrote:
Hi BI Masters!
I'm fairly new in the world of Power BI and came accross a problem that's puzzling me for quite some time now.
I have a table with columns for Country, Region, City and several numerical values. What I want to do is to create a column chart with drilling option - without drilling. :)
So I'd have 3 slicers (country, region, store) and several IF THEN options. IF nothing is filtered the chart would show data on country level. If country is filtered it'd show data on region level (for the selected country). If region is filtered it'd show data on city level (for the selected country / region). If city is filtered it'd show data for that one city alone.
My first thought was to create a calculated column that'd copy the values from one of the columns based on the ISFILTERED function but because calculated columns are initialized on data load and not on user interaction it wouldn't work.
So here's my question: is it possible to create something like this?
AFAIK, it is not possible at this moment, the X axis won't change without a manually drill down. You can submit your idea at Power BI Ideas and vote it up.
1 Reply
Eric_ZhangMicrosoft Employee
Warhawk wrote:
Hi BI Masters!
I'm fairly new in the world of Power BI and came accross a problem that's puzzling me for quite some time now.
I have a table with columns for Country, Region, City and several numerical values. What I want to do is to create a column chart with drilling option - without drilling. :)
So I'd have 3 slicers (country, region, store) and several IF THEN options. IF nothing is filtered the chart would show data on country level. If country is filtered it'd show data on region level (for the selected country). If region is filtered it'd show data on city level (for the selected country / region). If city is filtered it'd show data for that one city alone.
My first thought was to create a calculated column that'd copy the values from one of the columns based on the ISFILTERED function but because calculated columns are initialized on data load and not on user interaction it wouldn't work.
So here's my question: is it possible to create something like this?
AFAIK, it is not possible at this moment, the X axis won't change without a manually drill down. You can submit your idea at Power BI Ideas and vote it up.