Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

issues with Data Relationship

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 relationshi...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    HI Anonymous,

    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

    Power bi data model instance 

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous,

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