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.
Hello,
I am trying to recreate a dashboard created by a departed team member. It seems like an easy question, but I am a bit confused
In the model there is a hidden table with no relationships
When you go in the data view, this below is what the table contains.
Since this was created in dax and not power query (table is not present in power query), I am thinking it was created by using ‘Enter Data’.
My question is, How is it that this ‘period’ column is being used in a visual as a column and is able to communicate with other tables and measures. Have you even seen this before?
Any assistance is much appreciated
Solved! Go to Solution.
HI @salman_ali,
These hidden features are suitable with the 'data view' level that you used to design visuals. If you change to data table views, this hidden field will also be displayed.
Currently, it not support to design totally hidden fields on the power bi desktop side. I think it might be a possibility if these changes are directly applied in the data model side. You can use third-party tools to connect and check the data model instance if it helps.
External tools in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
Hi @salman_ali,
In fact, current power bi can use some advanced methods to interact with different table records without relationships.
The first way it uses measure filter based on expressions (apply on 'visual level filter') to interact with selections from slicer selections.
In addition, you can also direct invoke table values in calculated column/table expressions. (e.g. create a calendar table based on another table min/max date values; calculate rank based on the median value of another table records)
Regards,
Xiaoxin Sheng
You can, yes. If you dowload the Vertipaq Analyzer and hook it to the model you will be able to see all of the measures that exist in the model pulled into excel. Then you could search for that table name and see where it is used.
https://www.sqlbi.com/tools/vertipaq-analyzer/
They could be showing it in a slicer then have a measure that reads the selection and uses a switch to return the measure that corresponds to the selection.
Display Value =
VAR TimePeriod =
SELECTEDVALUE ( TimeCalGroup[Periods] )
RETURN
SWITCH (
TimePeriod,
"Last 2 Weeks", [Last 2 Weeks Measure],
"MTD", [MTD Measure],
"QTD", [QTD Measure],
etc..
)
They may also be using it in a calculation group.
is it possible that this measure is hidden? because i cannot find it?
HI @salman_ali,
These hidden features are suitable with the 'data view' level that you used to design visuals. If you change to data table views, this hidden field will also be displayed.
Currently, it not support to design totally hidden fields on the power bi desktop side. I think it might be a possibility if these changes are directly applied in the data model side. You can use third-party tools to connect and check the data model instance if it helps.
External tools in Power BI Desktop - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
hmm interesting, yes there is a slicer on the page, so maybe they are using that technique. I can't seem to locate that measure though. Can they hide the measure?
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 |