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.
Solved! Go to Solution.
Hi, @Anonymous
Thanks for your feedback.
Please check the below picture and the sample pbix file's link down below.
It is summing up for the selected tables.
The additional measure was created and you can check in the sample pbix file.
If you do not want to see the different colors in the same city, you can simply take out Slicer Column from the Legend field described in the below picture inside the red color area.
https://www.dropbox.com/s/klvxocz4hfjsv20/acobat.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous Hey
What is your data source ? excel ,Azure ,sql server ?
if all table header is same then append it and create a final table
if no then use merge query to merge all col. in 1 final table in power bi itself or do it in data base to create a view with table all value in one place
.
or
just create a duplicate tab and change the col . ref for viz . it will save your time for formatting and aligning of titles.
The data source is Sharepoint
Hi, @Anonymous
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
I think you can create a slicer for table selection, and create a measure by using Switch Dax Function.
The measure is written in the sample pbix file.
https://www.dropbox.com/s/klvxocz4hfjsv20/acobat.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim I've been trying to implement this for the whole day. I have been unable to figure how to implement it for 15 tables.
Hi, @Anonymous
I don't know well about your case and data model, but if you have 15 tables, please try to create a slicer table (15 rows), and table select measure (sample is in my previous link).
Or, please share your sample pbix file, then I can try to have a look into it.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
HI @Jihwan_Kim below is a link with some sample data with only 3 files. What I want is for a slicer that will show me visualizations for the separate months.
- you can show visuals of Gender per City
- Gender per country
- Number of Cars per gender.
I really don't have a preference on what KPIs you want to represent. All I want is to be able to create a single visualization page for all the 3 reports and a slicer that I can switch between the three visualizations. I should be able to select all the 3 months on the slicer and view the combined visualizations.
Thanks in advance
https://drive.google.com/drive/folders/1MOtbTXLBwxzWIpX5YnCWR9hSFm6pRgt-?usp=sharing
Hi, @Anonymous
Sorry that now I am a bit confused.
Please check the link down below, and please advise whether I created the slicer in the way that you want.
https://www.dropbox.com/s/klvxocz4hfjsv20/acobat.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim Thank you so far for your solution. It was able to solve like 85% of my problem. I have not yet marked it as solution because I don't want the thread to close. One last thing, I want to be able to select the multiple tables and view the combined results
Thanks
Hi, @Anonymous
Thank you for your feedback.
You can simply drag the column that you want into the Field area like the below picture.
The link is down below.
However, if you want to compare tables, I strongly suggest make those tables into one table and use the month as a slicer.
https://www.dropbox.com/s/klvxocz4hfjsv20/acobat.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi @Jihwan_Kim
I apologize for the continued questioning. I appreciate your efforts. I am barely 1 month into Power BI.
It's great. I can select multiple columns but what I want to when I select multiple columns is to be able to see the joint visualization.
For example, if is select January and February, and I want to view the number of males per city, it should display the sum, not the bars of both months side by side.
I hope you understand me
Thanks in advance
Hi, @Anonymous
Thanks for your feedback.
Please check the below picture and the sample pbix file's link down below.
It is summing up for the selected tables.
The additional measure was created and you can check in the sample pbix file.
If you do not want to see the different colors in the same city, you can simply take out Slicer Column from the Legend field described in the below picture inside the red color area.
https://www.dropbox.com/s/klvxocz4hfjsv20/acobat.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi
This is what I want. One more thing how did you create the splicer table? Did you just use power query and put the names "Table1" and "Table2" in it, then it automatically connects to them or is there something I am missing out?
Thanks in advance
Hi, @Anonymous
Thank you for your feedback.
In my sample, because there are only two tables, I just created them by typing manually. I usually do not depend on auto-relationship-creation, but I always check the Model Pane. In this sample, there is no relationship between Slicer Table and other tables.
If you have many tables, I think there are a few more other ways to create this. For instance, as you mentioned, inside Power Query Editor.
Thank you.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Anonymous , when you have a common dimension you can create that. even if I do not have one I can create one, but that will not interact
You can create visuals across common dimensions and slicers. What is the challenge?
The challenge I have is how to create it. I am still new to Power BI and the resources online are not really helping me
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |