Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I have 1 excel file that contain columns and connected to "dates" excel,
in the excel file I have many columns, I want to create a table like the pic below :
when the rows are columns from the wxcel and the columns are coming from dates
the problem is that under regular table visual I dont have columns (reating one columns of dates)
and at pivot the rows and getting into levels,
any idea what to do? thanks
Hi @TomerIwanir1 If I understood your concern correctly. You are looking for stepped layout in matrix visuals. Which will add new columns instead of hierachy view . Try turning off stepped layout in matrix visual.
@TomerIwanir1 Not quite sure I understand this. Maybe try a Matrix visual though.
It wont work
As matrix visual will create one row and the next one will be in hiercachy when Im looking for different rows
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
14 | |
12 | |
11 | |
10 | |
9 |