Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Morgana_2022
Helper I
Helper I

table properties

Hi,
it is possible to lock a column of a sample table view (like in excel)?
Thanks to those who will help me.

4 REPLIES 4
v-yangliu-msft
Community Support
Community Support

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:

vyangliumsft_0-1658905680964.png

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

Fowmy
Super User
Super User

@Morgana_2022 

Would you be able to provide more details and explain your question?


Did I answer your question? Mark my post as a solution! and hit thumbs up


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...

prova.png

@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/


 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors