- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table visual - split into to or more visuals?
Hi,
I have the following problem. I am supposed to make a one pager with some information from several tables.
I can display all the information in one table visual without any problem but then people need to scroll and do not have all the information available.
I was wondering if there exists something like a table grid for Power BI which would be able to split one table into two or more to see more data in one view.
Example: I would like to split this table in a visual! (not in PowerQuery)
Key | Name | Year |
1 | A | 2000 |
2 | B | 2002 |
3 | C | 2000 |
4 | D | 2003 |
5 | E | 2004 |
into something like
Key | Name | Year |
1 | A | 2000 |
2 | B | 2002 |
and next to it should be a table like this:
Key | Name | Year |
3 | C | 2000 |
4 | D | 2003 |
5 | E | 2004 |
Any ideas?
A few ideas are in my head like a measure which would only show the first x entires and then the rest. Or I have to create several tables in PowerQuery which I do not really want to do.
Thanks for the help.
Best
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @tmul ,
Is this the result you want?
Please create 6 new columns like below:
Key1 = SWITCH(
TRUE(),
'Table'[Key] = 1,1,
'Table'[Key] = 2,2,
BLANK()
)
Name1 = SWITCH(
TRUE(),
'Table'[Key] = 1,"A",
'Table'[Key] = 2,"B",
BLANK()
)
Year1 = SWITCH(
TRUE(),
'Table'[Key] = 1,2000,
'Table'[Key] = 2,2002,
BLANK()
)
Key2 = SWITCH(
TRUE(),
'Table'[Key] = 1,3,
'Table'[Key] = 2,4,
'Table'[Key] = 3,5,
BLANK()
)
Year2 = SWITCH(
TRUE(),
'Table'[Key] = 1,2000,
'Table'[Key] = 2,2003,
'Table'[Key] = 3,2004,
BLANK()
)
Name2 = SWITCH(
TRUE(),
'Table'[Key] = 1,"C",
'Table'[Key] = 2,"D",
'Table'[Key] = 3,"E",
BLANK()
)
Create a table visual and put [Key2] into filters pane like below:
Please refer the attached pbix file.
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@tmul , refer if this can help
https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-22-2023 01:23 PM | |||
08-02-2024 04:52 AM | |||
06-12-2024 07:40 AM | |||
03-12-2024 06:12 AM | |||
06-07-2024 02:17 PM |
User | Count |
---|---|
126 | |
79 | |
60 | |
58 | |
44 |
User | Count |
---|---|
181 | |
121 | |
82 | |
70 | |
54 |