Tahreem24's avatar
Tahreem24
Super User
4 years ago

Disconnected Table to create Dynamic Measures

Hi Community,


I have designed the Power BI
 Report which aids you to demystify "π‘«π’Šπ’”π’„π’π’π’π’†π’„π’•π’†π’… 𝑻𝒂𝒃𝒍𝒆" concept. This is also a frequently asked Interview question like "How or why do we use a disconnected table ?"  

I have taken all possible measures of Sales Domain and depicted them on the Combo Chart. You can easily select whatever measure you want to see by selecting Bar Value Slicer (Time Intelligence Measures) and Line Value Slicer ( Variance % Measures).

𝐏𝐞𝐫𝐀: We can showcase multiple measures on a single chart which saves canvas space and give flexibility to users to select whatever KPI they want to see.


1 Reply

  • Icad01's avatar
    Icad01
    Kudo Collector

    Nice work πŸ™‚
    I guess you will get more Likes if you give the pbix file πŸ˜‰