Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 table 2 as well when I select month name from Calendar table. I've created relationship but it doesn't work out for table 2. Please help me.
Kind regards,
pv
Solved! Go to Solution.
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,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |