Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am using switchs like this to dynamically change my columns in a table:
-1 =
SWITCH(
[Selected Measure],
1,[Users_M1],
2,[Users_Q1],
3,[Users_Y1]
)
-2 =
SWITCH(
[Selected Measure],
1,[Users_M2],
2,[Users_Q2]
)
-3 =
SWITCH(
[Selected Measure],
1,[Users_M3],
2,[Users_Q3]
)
my measure switch table
1) How can i add no columns if there is no values or column doesn't exists ? (year -2 and year-3 doesn't exists)
2) How can i dynamically rename the column name in my table "-1" to "-1 Month" if the selection is 1 or "-1 Quarter" if the selection is 2 ?
Solved! Go to Solution.
If you're talking about raw tables in PBI, then they must be static out of necessity. You can't change them on the fly. Easy as that. If you're talking about visuals... then some of the functionalities might not be available, either. For instance, I don't think you can dynamically change the headers of a column in a matrix or table visual.
If you're talking about raw tables in PBI, then they must be static out of necessity. You can't change them on the fly. Easy as that. If you're talking about visuals... then some of the functionalities might not be available, either. For instance, I don't think you can dynamically change the headers of a column in a matrix or table visual.
@Anonymous ,
1. I think you need to have a default value in case of measure slicer
2. You can rename title , I doubt you can rename column based on selection
also refer
measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME
@amitchandak i have already a default mesure ans i return dynamicaly thetable n'aime with another measure. Thank toi for tour Reply.
@Anonymous Hello, in fact i would like a Dynamic column name shown in m'y Matrix visual depending on my selection.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |