Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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êsUser | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |