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.
Did anyone work on Dynamic filtering in Powerbi. There are 2 reports like A and B. In the report A i have given url of report B. for the same link im passing the filters like month, Whatever the values are in the month its splitting the aggregated data. I dont wan't to split the data. I need aggregated data only even if the month is having multiple values. If you see the image you will get better understand.
Thanks in advance if anyone gets the solution
@harib ,
"Whatever the values are in the month its splitting the aggregated data. I dont wan't to split the data. I need aggregated data only even if the month is having multiple values. If you see the image you will get better understand.“
<--- What does "split the data" mean? Could you clarify more about this issue?
Regards,
Jimmy Tao
Hi Jimmy Tao
I have attached sample PBIX file.
https://drive.google.com/file/d/1EqH65g7-BDH9cBGx6CNuBFjAdrNgp5Xd/view?usp=sharing
LINK = "https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/Crosstab-report-module-2-topic-8/t... eq '"&'Table1'[Values]&"'"
In the above LINK i have passed Table1'[Values] as a filter. Table1'[Values] is having only 1 attribute. So On_Time_Count is showing 102. That's fine.Check Table 1 image
In the above LINK2 i have passed Table1'[Values] and Table1'[LINE_ITEM_TYPE] as a filter. Table1'[Values] is having only 1 attribute and Table1'[LINE_ITEM_TYPE] is having 2 attributes. So On_Time_Count values are splitted into 2 beacuse of Table1'[LINE_ITEM_TYPE] having 2 attributes. Check Table 2 image. I dont want to split the values even if the values are having multiple attributes.
I hope you understand the concept and kindly provide me the solution if it's possible.
Note: The link which i have used is dummy, but concept is same from ........?filter=
Thanks in advance.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |