needs help
4 Topics
Assistance in a simple Report
Hi Everybody Please assist me, I am new to PowerBi Report services. I have started designing a report based on a Powerbi data source. I have 2 Tables - Company and Shareholders. Thank you for your assistance. Output I want the report to have first a table showing the company details. A second table below will show its shareholders only ( based on the Company selected) Parameters: ( 2 of them) 1: Drop box of complanies as per data input in parameter 2, which is a Next Review Date. Only companies with Next Review Date <= "User input date ie [arameter 2" gets populated' In my example, user choses 30 April 2024 in parameter 2, Only CPY A and Cpy B get populated in parameter 1. User selects CPY A and the shareholder table is filtered accordingly. Sample Data Table Company Company Next Review Date Manager CPY A 12-Feb-24 Lee CPY B 18-Jan-24 Rob CPY C 12-May-24 Sue CPY D 18-Jun-24 Suzy Table ShareHolder Company ShareHolder Name CPY A Jack CPY A Mary CPY B Helen CPY C Jelly CPY C Francis Report Layout Company basic Company Manager CPY A LEE Shareholders Company Shareholder Name CPY A Jack CPY A MarySolved647Views0likes1Comment
348Views0likes0Comments
