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.
Tell me please There is a column "Aggregate name" in this column there are different names of signals. I don't like these names and I want to rename them, for this I use the SUBSTITUTE command.
Code:
Name of the units= SUBSTITUTE([Unit name],"DB signal ","Signal 1")
Let's say that at some point in time I want to rename it from "Signal 1" to "Signal 2" After renaming, the filters will go wrong
How can I make sure that the filters on DAX do not get lost after renaming?
Create a separate column with the ID of each signal. Base your filters on the ID column. Then you can change names without impacting the result.
I tried to do it via SWITCH, but nothing worked
Aggregates name = SWITCH( TRUE(), [Aggregate name] = "LD11_Cnt_weight_1","LD11: Scales No.5", [Unit name] = "Cnt_Saw1_CutStart","Saw 1-n", [Unit name] = "Cnt_Saw2_CutStart","Saw 2-h2")
Can you send me a sample code?
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 | |
11 | |
10 | |
9 | |
8 |
User | Count |
---|---|
17 | |
12 | |
11 | |
11 | |
10 |