Custom Reporting Requirement

[suyogbi]

Hello Everyone,

My client has unique requirement explained as below.

Requirement has tab called Comparison as shown below,

once the user selects Eq type then create group 1,2 will be enabled to select list of Assets/equipments/Systems, as shown below,

Once we click on Create Group 1 then following screen should come, This will intern have same metrics that should be shown in comparison window. Here in this window these metrics are restricted to single asset/system and it should be displayed as below Metric name, above the name metric name corresponding values for each Asset/System. User should be able to select Multiple Assets/System.

once we select the Asset/Equipements, SAVE button will be enabled, Once we click on save below screen should come. By Default this screen should display avg values for selected Assets, if we click on down arrow then it should show Asset wise values.

Same process follows to select Group 2 Assets.

Once we select Assets for both Groups, below comparison should be displayed.

 Can you PLease let me know How to achieve this?

Is it Fesible in Power BI to implement this requirement?

Any workarrounds, Any leads will be help full..

Thanks In Advance,

Suyog

[v-luwang-msft]

Hi @suyogbi ,

Is there a base table of relevant data(remove confidential data), the main function of Power BI is data analysis as well as presentation.

Best Regards

Lucien