Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
So I have two tables that show our monthly supply of inventory. We have two categories: New Construction and All Construction
The left table is New Const. and the right table is All Const.
This is the chart I have created. The issue I am have is I want to have a slicer that consists of all the price ranges that are the column headers. So basically I want the price range slicer to show the appropriate value when selected. I'm not sure if I need to edit the entire table in power query or not. Thanks in advance!
Hi, @kboud3
the best approach is typically to unpivot your data to transform your column headers into row values.
Table should look like
Type Price Range Value
New Construction | 0-100K | 10 |
New Construction | 100K-200K | 15 |
New Construction | 200K-300K | 20 |
All Construction | 0-100K | 5 |
All Construction | 100K-200K | 10 |
All Construction | 200K-300K | 15 |
Proud to be a Super User!
Will I be able to put the months on x-axis by doing that? I don't want to input any data because the excel spreadsheet will continuously be update.
Hi @kboud3 ,
Unpivot your data does not affect the refresh of your data. Unpivot is a feature in Power Query that also doesn't enter new data. In Power Query, you can transform columns into attribute-value pairs, where columns become rows. More details refer to
Unpivot columns - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |