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 All,
Generally we will get date hierarchy as Year,Quarter,Month and Day. Is it possible to have these 4 values in filters under date column so that if i select "Day' then it need to show data on daily basis and when i select "Month" then it will be showing data on monthly basis.
We can do this with the help of button using bookmark but i would like to have these 4 values in a slicer i.e., filters.
Thanks in advance.
Regards,
Prakash
Solved! Go to Solution.
Hi Guys,
I got the solution. I was facing problem similar to the below link.
https://community.powerbi.com/t5/Desktop/Column-Selection-using-a-Disconnected-table/td-p/606303
Thanks for your respose.
Regards,
Prakash
Hi @Anonymous ,
Do you want to change the column in table visual based on the value you selected in another slicer? Or expand columns?
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Guys,
I got the solution. I was facing problem similar to the below link.
https://community.powerbi.com/t5/Desktop/Column-Selection-using-a-Disconnected-table/td-p/606303
Thanks for your respose.
Regards,
Prakash
Hi All,
Is there any other way apart from this? Please refer the below URL
https://community.powerbi.com/t5/Desktop/Column-Selection-using-a-Disconnected-table/td-p/606303
Can we do it without duplicating the record or without creating the bridge table?
Regards,
Prakash
Hi @Anonymous ,
The date hierarchy that is created on PBI is a virtual one and does not result from different columns in the database but from the date columns.
For having this type of slicer (Day, Month,Quarter, Year) you need to create a disconected table on your model and then make your measure to work uppon this nem table.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |