Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a visual input of hierarchy level. How can I rename it? I was able to rename regular input field, but not hierarchy.
Regards,
Yerkhan
Solved! Go to Solution.
Hi @ysapiyev,
Based on my test, Live connection limits the data hierarchy function, you can not use it.
Regards,
Daniel He
Hi @ysapiyev,
In your scenario, if your data is a date hierarchy and it is automatically generated in Power BI like the picture below.
You can't rename the hierarchy, but you can create several related calculated columns to recreate a designed customized hierarchy. Now you can create these calculated columns.
Day = DAY('Table1'[Date])
MONTH = MONTH('Table1'[Date])
Year = YEAR('Table1'[Date])
Quarter = "Q" & INT ( FORMAT ( [Date], "q") )
Put the [MONTH] field into the [Year] field. Now you can see a new hierarchy. You can also put the [Quarter] and [Day] fields into this hierarchy and you can rename it now.
You can also download the PBIX file to have a view.
Regards,
Daniel He
So, if I understood correctly, it only applicable to imported data, right?
Regards,
Yerkhan
Hi @ysapiyev,
Based on my test, it depends on how your data is connected.
If you are using the Direct Query mode, you can use the way I mentioned earlier. If you are using the Live Connection mode, I am afraid you can’t use the way. And both of them have no built-in date hierarchy.
If you are using the Import mode you can use the way easily.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Regards,
Daniel He
Hi @ysapiyev,
Based on my test, Live connection limits the data hierarchy function, you can not use it.
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |