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,
Don't think this should be complicated but has me stuck! It is something I know I can achieve in PowerQuery but need the row numbers re-asessed based on slicer options so hence I believe it needs done as a DAX measure.
Hi @Weegreen I just saw that order of my picture should be reordered (1st should be 2nd lol). I still do not get your request. Maybe you should try my approach for start, with your data.
As I understand you need slice interaction, which is fine. Still, what is your input and wanted output? Give us some examples for input/output.
Proud to be a Super User!
Hi @Weegreen I am not sure what you need exactly, but if for part "There are duplicate dates in this list which need given numbers different to one another." you could in PQ insert index column (in my case starting from 1)
I created test data, so 10.5.2023 and 12.05.2023 are duplicate dates so first picture below is before slicing and second is for slicing one date 10.5.2023. I hope this help
Proud to be a Super User!
Hi @some_bih,
Thanks for replying! If it helps clarify, what I mean by being re-indexed is in your first instance, the index would show 1 and 2. But in the second instance the index would show as it does in your photo. Does that clarify at all?
Thanks
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |