Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
it is possible to lock a column of a sample table view (like in excel)?
Thanks to those who will help me.
Hi @Morgana_2022 ,
Here are the steps you can follow:
1. Create measure.
Category_Measure =
IF(
HASONEVALUE('Table'[Title]),MAX('Table'[Category]),BLANK())
Prime_Measure =
IF(
HASONEVALUE('Table'[Title]),MAX('Table'[Prime Personal.Subject]),BLANK())
2. Result:
If you need pbix, please click here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
@Morgana_2022
Would you be able to provide more details and explain your question?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
yes,
i need to fix the first or more columns of a table chart and scroll through the others.
In the meantime, I have discovered that with the matrix chart it works, but I would like the totals only of the numerical values and not of the textual ones...
@Morgana_2022
Yes, you FREEZE rows and columns in Excel but in Power BI, that feature isn't available yet unfortunately.
I would encourage you to add it as an idea or vote for one if it exists: https://ideas.powerbi.com/ideas/
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |