User Profile
paw1
Helper I
Joined 3 years ago
User Widgets
Contributions
Field Parameter in Power BI
Hi, Please help me on below requirement. I have a source table like below. Source: Field Parameter: I have created a Field Parameter with NGT and Impact like below. Requirement is when NGT is selected only NGT=Yes related data need to be filter in below chart i.e., Retail Data. When Impact is selected only Impact =yes need to be filter in below chart i.e., Healthcare and Retail. But now the filter selection is not working in chart. Please help me on this . Chart: Thanks in advance.Re: Filter creation in Power BI
hi olgad I have a single table in report like below. when NGT selected from filter then NGT=Yes need to apply for all the visualizations in the sheet same for impact. INDUSTRY Status NUMBER OF Records NGT Impact Healthcare active 1 No Yes Healthcare active 1 No No Healthcare active 1 Yes Yes Healthcare high 1 Yes NoRe: Filter creation in Power BI
Hi olgad Thanks for your reply. I have tried like below. 1. Created slicer from parameter tab and added this slicer field in bar chart and selected Show Selected field but values are not changing in chart. Actually when I have select NGT field only Yes value from NGT field need to apply in bar chart . Please help me to qualify Yes from NGT and Impact. Select Business Filter = { ("NGT", NAMEOF('Asia Pipeline Analytic – Final'[NGT]), 0), ("Impact", NAMEOF('Asia Pipeline Analytic – Final'[Impact]), 1) }Filter creation in Power BI
Hi, Can any one please help me on below requirement. I have two fields NGT and Impact in table with Yes and No values. From these two filters need to create one common Selection filter like below with existing filter names. Then by selecting NGT in Selection Filter, NGT=Yes parameter need to filter in below visualization and similarly for Impact. By selecting Impact in Selection Filter, Impact=Yes parameter need to filter in below visualization. Thanks in advancehow to hide subtotals for particular measure
Hi, I have a pivot table with 5 measures. I have to hide subtotal values for only sale %. is there any way to convert sale % sub total value to 0 or completly hide the value. Sale % = if(FORMAT(SUM(Input[Sales]),"#,##0.00%")="0.00%","-", FORMAT(SUM(Input[Sales]),"##,###0.00%;(##,###0.00%); -")) ThanksRe: how to apply not null in List.contains in power bi
Hi Ahmedx Thanks for your help. It's the same scenario from this post. https://community.powerbi.com/t5/Desktop/Custom-Column-Creation-help/m-p/3124183#M1057680 I am looking for In first condition how to apply Alternate Num is not blank extra condition?
