2 datasets in Paginated reports using parameters
Dataset1 will be filtered by both Physician Organization and Date (monthly reporting) and DataSet2 will only be filtered by YearMonth. I created 2 new tables for both Parameters (YearMonth and PhysicianOrg). Dataset2 only references the yearMonth parameter which is what I want as I wish to COMPARE the OVERALL score to the score which will be filtered by both YEARMONTH and PHYSICIANORG. When I add a new table and reference dataset2 along with dataset1 in one table it does work. I tested this expression from Dataset2: =Lookup(Fields!YearMonth.Value, Fields!YearMonth.Value, Fields!ID_AllowedPMPMYTD_.Value, "DataSet2") (the numbers are not matching the excel formula which is =IFERROR(CUBEVALUE("Cube",GM,CubeMeasures!$D$25,CurrentMonth),0). (the current month is hardcoded and referenced I tried this expression inside the same table and referenced Dataset2 but that did not work. I am trying to match an excel formula report which uses HFPN overall is just AllowedPMPMYTD =CUBEMEMBER("Cube","[Measures].[AllowedPMPMYTD]") (it filters by month using How is this matched in Report Builder??? Do I need to use a DAX variation of CURRENT MONTH? I use the formula below sliced by yearmonth (SQL via Tabular Model) in Report Builder: The question is how do I show both results from 2 datasets in one paginated report? I just need one column with the same expression to filter differently: The Rate Column Filters by both parameters and the HFPN column filters by yearmonth column. Any suggestions? I created dataset2 just for HPFPN overall which I am currently hard coding until I can work this relatively simple problem out. EVALUATE SUMMARIZECOLUMNS('Providers'[PCPLocation], 'Providers'[PhysicianOrganization],'DateDim'[Year],'DateDim'[MonthNameAbbreviation],'DateDim'[YearMonth], FILTER(VALUES('Providers'[PhysicianOrganization]), 'Providers'[PhysicianOrganization] = @PhysicianOrganization),FILTER(VALUES('DateDim'[YearMonth]), ('DateDim'[YearMonth] =@YearMonth)), FILTER(VALUES('Patients'[Populations]), ('Patients'[Populations] = "GM")), "UniquePatients", [UniquePatients], "TotalCostYTD", [TotalCostYTD], "ERVisitsYTD", [ERVisitsYTD], "MemberMonthsYTD", [MemberMonthsYTD], "Admits1000YTD", [Admits1000YTD],"AntidepressantMedicationAcutePhaseNumerator",[AntidepressantMedicationAcutePhaseNumerator],"AntidepressantMedicationAcutePhaseDenominator",[AntidepressantMedicationAcutePhaseDenominator],"AntidepressantMedicationAcutePhaseRate",[AntidepressantMedicationAcutePhaseRate],"AnnualWellnessExamNumerator" ,[AnnualWellnessExamNumerator],"AnnualWellnessExamDenominator",[AnnualWellnessExamDenominator], "AnnualWellnessExamRate",[AnnualWellnessExamRate],"ERVisits1000YTD", [ERVisits1000YTD], "BloodPressureNumerator", [BloodPressureNumerator], "BloodPressureDenominator", [BloodPressureDenominator], "BloodPressureRate", [BloodPressureRate], "DiabetesHbA1cLessThan8Numerator", [DiabetesHbA1cLessThan8Numerator], "DiabetesDenominator", [DiabetesDenominator], "DiabetesHbA1cLessThan8Rate", [DiabetesHbA1cLessThan8Rate],"ReadmitsYTD",[ReadmitsYTD],"ReadmitsYTDRate",[ReadmitsYTD%],"AdmitsYTD",[AdmitsYTD],"AllowedCost",[AllowedCost],"AllowedCostYTD",[AllowedCostYTD],"AllowedPMPMYTD",[AllowedPMPMYTD],"BreastCancerScreeningNumerator",[BreastCancerScreeningNumerator],"BreastCancerScreeningDenominator",[BreastCancerScreeningDenominator],"BreastCancerScreeningRate",[BreastCancerScreeningRate],"ColorectalCancerScreeningDenominator",[ColorectalCancerScreeningDenominator],"ColorectalCancerScreeningNumerator",[ColorectalCancerScreeningNumerator],"ColorectalCancerScreeningRate",[ColorectalCancerScreeningRate],"DAWNumerator",[DAWNumerator],"DAWDenominator",[DAWDenominator], "DAWFillRate",[DAWFillRate],"ERVisitsRate",[ERVisitsYTDMoreThan5Visits1000],"ERVisitsNumerator",[ERVisitsYTDMoreThan5Visits],"LowBackPainImaging18to64Numerator",[LowBackPainImaging18to64Numerator],"LowBackPainImaging18to64Denominator",[LowBackPainImaging18to64Denominator],"LowBackPainImaging18to64InverseRate",[LowBackPainImaging18to64InverseRate],"LowBackPainImaging65to75Numerator",[LowBackPainImaging65to75Numerator],"LowBackPainImaging65to75Denominator",[LowBackPainImaging65to75Denominator],"LowBackPainImaging65to75InverseRate",[LowBackPainImaging65to75InverseRate],"VirtualNumerator",[OutpatientUtilYTD],"VirtualRate",[OutpatientUtil1000YTD],"DepressionScreeningNumerator",[DepressionScreeningNumerator],"DepressionScreeningDenominator",[DepressionScreeningDenominator],"DepressionScreeningRate",[DepressionScreeningRate],"DepressionPositiveScreenNumerator",[DepressionPositiveScreenNumerator],"DepressionPositiveScreenDenominator",[DepressionPositiveScreenDenominator],"DepressionPositiveScreenRate",[DepressionPositiveScreenRate],"CervicalCancerNumerator",[CervicalCancerNumerator],"CervicalCancerDenominator",[CervicalCancerDenominator],"CervicalCancerRate",[CervicalCancerRate],"GenericNumeratorYTD",[GenericNumeratorYTD],"GenericDenominatorYTD",[GenericDenominatorYTD],"GenericFillRateYTD",[GenericFillRateYTD],"April YTD","April 2024 YTD","Zero",0)
Field Parameter
Hi, I am using PBI RS with direct query to Tabular with roles. We want to show a different set of columns in an simple table object depending on roles permissions. Field Parameter seems to be the perfect match ! Is there any plan to include "Field Parameters" in Power BI Report Server ? Thanks and Regards, IlanParameters in Report Builder
Hey guys, I am building a report in report builder but want to add a parameter to filter the report but I want to have the filter be a column of names and then it will filter based on the name you select. This will also group all of the columns based on the selection. Is this possible? Any help or questions are welcomed!Dynamic Axis in Scatter Plot
I have been facing a challenge recently. In my company we are using Power bi Report server I'm trying to have a scatter plot with dynamic X and Y axis. This can be solved using Field Parameters but unfortunately it's not available in Power bi Report Server version May22. Example: Switch Case 1: Y axis : Cost (USD) X axis : Power(Horse Power) Switch Case 2: Y axis :Cost (Eur) X axis :Power (Kilowatt) Note: There can be multiple such currencies in Y axis. Also I don't want to use multiple visuals. Can you kindly let me know if there is solution to this with given constraint. Appreciate if you could help
