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.
I have a report which is connected to a dataset.
The report contains a number of measures which have been created in the report .pbix and are saved in measure tables.
The measure tables are blank tables in the dataset created for the sole purpose of holding these report measures.
When I select a measure in the report, the 'Home Table' option in the Modelling ribbon is greyed out. i.e. its not possible to change the home table of a measure after its been created.
In previous versions of the same report I've not had this issue. Any thoughts on what could be causing this? I've tried reinstalling Power BI desktop and the issue persists.
I am able to change the home table of meaure. I just tried at my end. By the way I am using Oct 2019 version.
Don't forget to hit Thumbs up and accept this as a solution if you find it helpful!
Hi @michaelmcm ,
I can't reproduce your issue, can you please share a sample file for test?
In addition, what version of power bi desktop are you test? Please share more detail information to help us clarify your scenario.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Unfortunately I can't share the file as the data is sensitive. I'm on version 2.76 (December 2019).
I am having a similar issue. It seems that, if a report is connected to a Power BI dataset and not directly to a model, changing a measure's home table is not possible. That is true for a measure created on top of a dataset.
Proud to be a Super User!
If you select a measure, you will see that a new tab appears in the ribbon with a header “measure options” (I’m talking from memory here, so apologies if it’s not the exact wording). Select this tab and you will see an option to display under which table to nest your measure.
Proud to be a Super User!
Paul on Linkedin.
Thanks, I don't get a separate tab on the ribbon. I have the Home Table option under the Modelling tab but its greyed out when I have this particular .pbix file open.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |