Forum Discussion
Help with data PowerBI Reporting
Hi all,
I have a few issues...
The data I have is around vehicle information - defects that are listed by VRN.
The data I am playing with is fixed into a column as shown below.
What I want to do is group by VRN and report on the <category>.01.<headername>, notice I only need the 01 values only...
How do I display this in a data grid by using some magic?
My data grid looks horrible as it has repeated values - I need it grouped by VehicleRegistration the repeats taken away.
I look forward to your assistance.
Thank you.
6 Replies
Hi there,
I think you have some options, but it is difficult to help you with such a limited amount of information, i.e. you have not explained how your data model is set up and what you want to achive, or how you arrived to this datagrid.
One thing that might help you if you only need the rows with ".01." is to filter on those rows in the Query Editor, and then split the columns on ".". Then you should have four columns with <category> <01> <headername> <headername2>, the last two could then be merged into one.
Another approach is to use DAX, where you would iterate the table and if the Key columns contains ".01." (you can use SEARCH) then you can take some action, SUM, COUNT, etc.
If you can share you file I guess someone can help.
Regards,
Kristjan
Hi,
As requested, actual data from the table I am using is within this link: https://we.tl/t-7a8W1C3qU5
Also, I would like to get the table to format to something like this - appreciate I am using other tables to get the Reg, Make, Model etc...:-The data should go through a sequence, i.e. Area, Sub-Area etc...
Hopefully all makes sense? I look forward to your response. Thank you!
