- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-04-2024 02:24 PM | |||
09-22-2024 10:17 PM | |||
09-22-2024 12:51 AM | |||
10-31-2024 04:29 AM | |||
02-07-2023 04:03 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |