Forum Discussion
Get data from table 2
Hi Guys, I hope you can help me. I'm new to the Power BI. Table 1: Data from Mar 19 - till date Table 2: Data from Jan 19 - Feb 19 Table 3: Calendar table I would like to get the data from...
Hi Anonymous ,
Your column chart's x-axis and y-axis are both from Table 1, not Table 2. So, it will show blank when you choose "January" or "February".
Try this:
1. Create measures. Please pay attention to your blank values in "Concatenate". Not blank, but " ".
Count of Defected data = IF ( MAX ( 'Data Collection'[Concatenate] ) = " ", BLANK (), COUNT ( 'Data Collection'[Concatenate] ) )Count of defected = IF ( MAX ( 'dCollection(Jan-Feb)'[Concatenate] ) <> " ", COUNT ( 'dCollection(Jan-Feb)'[Concatenate] ) )Defected all = IF ( ISBLANK ( MAX ( 'Concatenate'[Concatenate] ) ), BLANK (), [Count of defected] + [Count of Defected data] )2. Create a table.
Concatenate = FILTER ( VALUES ( 'Data Collection'[Concatenate] ), 'Data Collection'[Concatenate] <> " " )3. Create a column chart.
PBIX file attached.
Best Regards,
IceyIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I am not sure about the solution but i have a workaround you can try as of now.
Create a measure:
Measure = IF(
SELECTEDVALUE('Date'[Date]) = SELECTEDVALUE('Table'[Date]) ||
SELECTEDVALUE('Date'[Date]) = SELECTEDVALUE('Table (2)'[Date]),
1,
0
)
Put this in table visual and also on visual level filter, select value 1 and apply.
Thanks,
Vinay Dandwani
Hi Vinay,
Thank you so much for the reply.
I think your formula is correct but I'm not getting, it says can't display. Sorry, I think I'm doing something wrong.
Kind regards,
pv